Hello,
I am having a problem when using access 2000 to open a excel file using excel 97.
I have some VB code that runs on startup when the wb is opened. It is opened from a sub in the mdb file. Everything works fine when myself or someone else runs it using excel 2002 but when a excel 97 user tries it does not run the code at startup.
Here's the trick if the 97 user opens the file directly without going through the .mdb file everythign works fine.
Any ideas anybody? Any help would be appreciated
Thanks,
Brad
I am having a problem when using access 2000 to open a excel file using excel 97.
I have some VB code that runs on startup when the wb is opened. It is opened from a sub in the mdb file. Everything works fine when myself or someone else runs it using excel 2002 but when a excel 97 user tries it does not run the code at startup.
Here's the trick if the 97 user opens the file directly without going through the .mdb file everythign works fine.
Any ideas anybody? Any help would be appreciated
Thanks,
Brad