Answer Questions

• barkest Copying and pasting between spreadsheets

  I have an Excel Macro which copies from a Source spreadsheet and pastes on the working copy. The Source spreadsheet is the result of a report gleaned from a non Microsoft database. Usually all works as expected. The problem comes when one of the items in the working copy does not appear in the Source copy. (If no activity occured, instead of displaying a zero, that particular item is excluded from the output. Since the procedure is copying an ...Show All

• FredDC Display a drawing on an MS Access Form

  Hi there i would like to display a drawing (test.dwg) on my form in a vb code. The form has an Bound Object Frame - OLE1 area. So when the i press an button it should display the diagram itself (not the link) inside the Bound Object Frame and be able to zoom in and out and edit. Thank you Per our support engineer: Base on my understanding, our buddy wants to insert "SmartSketch.Document" object (a ...Show All

• MarcLile accessing VBA code from VB.net application

  I have a VBA code as a part of a front end MS Access application. I am interested in knowing how I can call a method in this VBA code from a VB.net application of mine Per our support engineer: I am not sure how you want to use this VBA code method. If you want to call this VBA code method like other methods or functions created in .NET assembly, it is not possible. The VBA code method is defined in Access ...Show All

• CuSOUN Help Event

  I want to create a procedure that when I add ou delete one sheet, it will call a sub or execute a code. Someone know I WANT HELP!   you can add code to the NewSheet event of the workbook when you add a new sheet, but I cannot find an event that's raised when a sheet is deleted. Mr Excel suggests this workaround http://www.mrexcel.com/archive2/4900/5453.htm ...Show All

• Tolle Loosing Reference to Common Objects (i.s. VBA)

  Even though I have the VBA reference checked in VB I am not able to access the methods therin unless I actually key the VBA object first Anyone know why this may be happening Simple fix: add the line "Imports VBA" at the top of your file. Adding a reference allows you to access the methods but you would still need to fully qualify them Adding the imports statement allows you to avoid hav ...Show All

• John Chorlton Getting New Textbox value without using Afterupdate

  Hi. I'm fairly new with programming and I hope someone can help me with this. I trying to filter a list based on the value entered on a textbox but the only way I know of getting the new textbox value is wait for the AfterUpdate event. This works fine but I need to activate the filtering routine as the user types in the new value. Im thinking of using keypres, can anyone show me a way doing this. Any help would be appreciated. Thanks ...Show All

• ?培 BSC manager - Error connecting to server

  I've installed BSC manager 2005 following these steps: 1. Created a Virtual PC with 512 MB RAM 2. Installed Windows Server 2003 entreprise edition 3. Installed Windows Server 2003 SP1 4. Installed Sharepoint Services 2003 5. Installed Sharepoint Services 2003 SP2 6. Created a site and extended (Port: 46786) 7. Installed SQL 2005 developer edition 8. Configured SPS to use SQL instance 9. Installed BSC manager (server an ...Show All

• Kerem Baser VBA code in Dutch

  Hello I was trying since few days ago to figure out why some simple Excel vba code is not working for a dutch client. It seems that VBA has been translated to dutch Property like Textbox1.Left may be TextBox1.Links Please help me understand how can I have same runtime vba as my client as I tried everything an d still end up with english version. I installed Dutch office with no luck. Do I need OS in dutch also Thank you very much, Cristian Rus ...Show All

• John Knoop Internet Explorer Problem?

  Hi, Im having a very strange problem and Im wondering if it is a setting in Internet Explorer. I tried to access an online shopping cart in IE, and could not get to the Payment page. It simply looped around and endlessly asked me for my details. You might be thinking that this is just a badly designed website, however, i tried to do this on other machines and it worked perfectly fine! Is there a setting in IE that doesnt allow access to intera ...Show All

• Holyping Speed up processing time Excel Macro

  I had some questions about Office and performance. I would like to figure out what specifically will affect the runtime of macros in Excel. Currently this user has a Dell Optiplex GX520 with the following specifications: IntelR PentiumR 4 Processor 640 with HT (3.2GHz, 2M, 800MHz FSB) 1.0GB DDR2 Non-ECC SDRAM,533MHz, (2DIMM) 80GB SATA 3.0Gb/s and 8MB DataBurst Office 2000 Pro She is running macros in large Excel spreadsheets (30 - 60MB) that ...Show All

• rfryer Excel macro not able to SetSourceData for chart

  I am trying to write a macro for excel, and I can't seem to get it to work the way I want. I create xy scatterplots with a specific format all the time, so I need this macro to automate this task. So, I used the "record macro" function to record all the steps. First I selected the range of cells with the data A1:B5, then started the recording. Now this macro works just fine when the data is in cells A1:B5. But I need this macro ...Show All

• Vapor can we do this in vba

  I developed a small windows appln in vb.net 2005 which uses MS-Access2003 as backend I want to give my own protection to this MS-Access file when i try open the access file, it should display my own Enter password dialog box for password I also want to mainain the user credentials in this access file Can we do this in VBA Hi, You shouldn't need to use VBA. If you load your database and select To ...Show All

• Klaus Even Enevoldsen DK copy chart from excel to word

  The advance report currently made manually, make chart in excel, then copy it in word by hand, add adequate data, put it in nice layout, and print it. My project is to generate an advance report automatically, just push a few button, and the report is ready to be printed. My progress so far, I had a code to generate chart(s) and put it in new workbook .why not in the same workbook Because I want to separate the program and the result, s ...Show All

• Padma Read data from excel through VB.NET

  Hi friends, I need to read symbols(like ALPHA,BETA,MEU) from excel and show it in a data grid through VB.NET.Later insert it into Oracle 8i DB. I am able to read entire data but i am getting 'a' instead of ALPHA symbol and 'b' instead of BETA symbol. I am querying excel via OLEDB provider.The following snippet is using for accessing excel. Dim MyCommand As System.Data.OleDb.OleDbDataAdapter Dim MyConnection As System.Data.OleDb.OleDbConnection ...Show All

• Brent Scott programming with MS Office components

  Hi I have a background in programming, but I'm new to programming with VB. I'm writing a code whose purpose is for students to practice their skills in MS Office applications ( Excel, Word, Powerpoint, Access). The interface consists of a form ( let's call it "question-form") that's positioned just above the Taskbar and it's always on top, because it displays the exercises the student has to perform. The rest of the scr ...Show All