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.
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.