| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel XP 2001 vs Excel XP 2002
I created a dialog box in Excel XP VB 2001. I then use the
excel sheet on a desktop that has Excel 2002 XP, the dialog box keeps giving me compile errors that it can't find certain objects in the library. These are simple objects such as text boxes. The funny thing is that we use the same image on all the PC's, some pc's have this issue and some don't. Am I missing a patch? I've checked to see if everything is registered and it looks good. Help! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel XP 2001 vs Excel XP 2002
On the problem PC, go to the VBA Editor, then the Tools menu,
then References. Check to see if any libraries are marked 'MISSING'. If any are, and you don't need them, uncheck the reference. If you need the reference (e.g., MSForms), close Excel, and go the Windows Start menu, choose Run, and enter the following: Excel.exe /regserver -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "jondrig" wrote in message ... I created a dialog box in Excel XP VB 2001. I then use the excel sheet on a desktop that has Excel 2002 XP, the dialog box keeps giving me compile errors that it can't find certain objects in the library. These are simple objects such as text boxes. The funny thing is that we use the same image on all the PC's, some pc's have this issue and some don't. Am I missing a patch? I've checked to see if everything is registered and it looks good. Help! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel XP 2001 vs Excel XP 2002
Worked like a charm, was excel trying to use the missing
library? -----Original Message----- On the problem PC, go to the VBA Editor, then the Tools menu, then References. Check to see if any libraries are marked 'MISSING'. If any are, and you don't need them, uncheck the reference. If you need the reference (e.g., MSForms), close Excel, and go the Windows Start menu, choose Run, and enter the following: Excel.exe /regserver -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "jondrig" wrote in message ... I created a dialog box in Excel XP VB 2001. I then use the excel sheet on a desktop that has Excel 2002 XP, the dialog box keeps giving me compile errors that it can't find certain objects in the library. These are simple objects such as text boxes. The funny thing is that we use the same image on all the PC's, some pc's have this issue and some don't. Am I missing a patch? I've checked to see if everything is registered and it looks good. Help! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| autofill using mouse is not working in excel 2001 | Excel Discussion (Misc queries) | |||
| HELP - Excel Date defaults to 2001 | Excel Discussion (Misc queries) | |||
| how can I turn a spreadsheet from excel 2001 to into a xml file | New Users to Excel | |||
| Unable to Start Excel Event ID 2001 | Excel Discussion (Misc queries) | |||
| Excel 2000 Windows VBA vs. Mac Excel 2001 VBA | Excel Programming | |||
Hybrid Mode
