Excel VBA apps inconsistency - urent help needed

info363 · Mar 18th, 2002, 08:05 PM

Hi,
I have a simple MS Excel (97) macro application used for validating data and to export to MS Access 97 database. This VBA macro runs well in some PCs but not in others. The OS is Win 98 and Apps is MS Office 97. The error messages in PCs where it is not running are:
"Compile error in hidden module: gMod" in some other machines I get the message
"Unable to connect to database"
This is very strange as the same Excel macro is running smoothly in some PCs with the same type of OS Win 98 and Office 97 apps. Have checked the add-ins under tools and there seems to be no problem with it.

Please advise if any specific ADO or Object libraries that I should install in machines where I am not able to run it. What other reasons could be for this problem? Your early help will be much appreciated.

Thanks.

Juan Pablo González · Mar 18th, 2002, 08:08 PM

When you run the code, look in the VB menu Tools, References, and look for any "MISSING" there...

Mar 18th, 2002, 08:08 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	When you run the code, look in the VB menu Tools, References, and look for any "MISSING" there... __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 18th, 2002, 08:05 PM	#1
info363 New Member Join Date: Mar 2002 Posts: 1	Hi, I have a simple MS Excel (97) macro application used for validating data and to export to MS Access 97 database. This VBA macro runs well in some PCs but not in others. The OS is Win 98 and Apps is MS Office 97. The error messages in PCs where it is not running are: "Compile error in hidden module: gMod" in some other machines I get the message "Unable to connect to database" This is very strange as the same Excel macro is running smoothly in some PCs with the same type of OS Win 98 and Office 97 apps. Have checked the add-ins under tools and there seems to be no problem with it. Please advise if any specific ADO or Object libraries that I should install in machines where I am not able to run it. What other reasons could be for this problem? Your early help will be much appreciated. Thanks.