Macro using Visual Basic
Using Visual Basic, I need to choose XYZ information in a cell, in Excel, and another cell must give me ABC predetermined information. How should I do that?

Answer Question   |  October 23, 2012  4:28 PM
Excel 2003, Excel 2003 macros, VBA, Visual Basic

Message Alert Box in Excel 2003
I have a two files, one is the consolidated time monitoring and the other file is the individual time monitoring. The individual time monitoring file has 30 sheets which is the name of each agent and in shared mode. On that file, agents are responsible to provide/indicate the things that they’ve done everyday…for the whole week. [...]

Answer Question   |  December 25, 2010  10:30 AM
Excel 2003, Excel 2003 functions, Excel 2003 macros, Excel macros

Excel 2003 Macros with Org Chart Parent
Hello, I have a corporate org chart for which I am trying to write a macro. The Excel workbook is set up so that each company is in a unique cell. The subsidiary is one column to the right. For instance, I would like to return the values in the far right column for the [...]

Answer Question   |  March 11, 2011  3:53 PM
Excel 2003, Excel 2003 macros, Excel macros, Excel Tables, Excel VBA, Macros

VBA macro to search macros in workbooks
I have an Excel macro that will search folders for .xls workbooks and can open them. Now I need to search the macros for any reference to a unc path. How do I search a macro?  

Answer Question   |  August 3, 2010  2:54 PM
Excel 2003 macros, Microsoft Office VBA

Getting rid of multiple macro copies in Excel 2003
Somehow, in Excel 2003 I have 4 copies of the same macro on the toolbar (not sure how that happened).  However, when I click on Tools>Macro>Macros, there are no macros shown, and all options are grayed out except Cancel.  When I go to Tools>Add-ins, one copy of the macro is shown, and it is checked.  [...]

Answer Question   |  April 24, 2010  6:06 AM
Excel 2003, Excel 2003 macros, Windows XP, Windows XP administration

Microsoft Excel 2003 Macros
I have an shared excel workbook that has a macro for auto save (update), The problem users are having is while working on different excel workbooks not linked to the shared workbook, when the auto save starts on the shared workbook all other excel workbooks become inactive until the auto save is complete. Is there [...]

Answer Question   |  March 30, 2010  12:45 PM
Excel 2003 macros

Missing reference to Microsoft Office 11 Object Library
Using MS Office Excel 2003 on XP I have written a number of macros that use the following code, With Application.FileDialog(msoFileDialogFilePicker)…. Something (?) has happened and now this portion doesn’t work any longer.  When clicking on the macro I get the error variable not defined with the msoFileDialogFilePicker highlighted.  When I look at the references [...]

Answer Question   |  September 30, 2009  1:29 PM
Excel 2003 macros, VBA EXCEL 2003

Horizontal to vertical
how do you change a horizontal excel 2003 spreadsheet with qty breaks to a vertical speadsheet with quantitiy break or is there a marco

Answer Question   |  April 13, 2009  8:09 PM
Excel 2003, Excel 2003 macros, Excel macros, Microsoft Excel

Excel 2003 Help: How to delete duplicates from specific colums and criteria
Hi I have already sent my question here: http://www.vbforums.com/showthread.php?p=3477514#post3477514 But I will ask the same again: In my Excel file I have several columns and lots of rows. I want the macro to check the column named REF (let say it’s in the B column). And it will check if other data contains the exact [...]

Answer Question   |  March 24, 2009  11:02 PM
Excel 2003 macros, Microsoft Excel 2003, Microsoft Excel 2003 macros, VBA, Visual Basic for Applications

I am getting “compiler error in hidden module” error in Excel 2003 while running Macro
I am getting :”compiler error in hidden module ” error in EXCEL 2003 only while running MACRO. Actully this MACRO is running on some PCs & for some PCs it is showing that error. The installation of MS EXCEL 2003 is same on all PCs. Please help me ASAP. Thanks in advance !

Answer Question   |  December 4, 2008  7:24 AM
Compile error in hidden module, Excel 2003, Excel 2003 macros, Excel macros, Microsoft Excel, Microsoft Excel 2003, Microsoft Excel error messages

Microsoft Excel 2003 Macros
I am wondering if there is an easy way to remove macros from an Excel 2003 workbook. Several of our users have had emails with Excel attachments rejected due to the macros they contain.

Answer Question   |  November 16, 2008  3:18 AM
Email attachments, Excel 2003, Excel 2003 macros, Excel macros

Excel macro between worksheets
I have an Excel Workbook with a “Paid” sheet and an “Outstanding” sheet, both sheets have a File Number column. I would like to create a macro that looks through the “Outstanding” sheet and if the File Number from the “Outstanding” sheet is also in the “Paid” sheet can the entire row be deleted from [...]

Answer Question   |  November 26, 2008  4:59 AM
Excel 2003, Excel 2003 macros, Excel macros, Microsoft Excel