Results 1 to 1 of 1
2002-11-11, 17:07 #1
- Join Date
- Sep 2001
- Stuck at work..., Missouri, USA
- Thanked 0 Times in 0 Posts
Project Breaks Excel Automation (A97/Excel XP/Project 2000)
I have a user who called me about an Access DB that worked on Friday, but not today... (If I had a dollar for every time...) She said she installed Project 2000 between the last time she used it and today.
Turns out the code that it now hates is along the lines of this:
Dim objXL as New Excel.Application
When running, it errors on With objXL and says Error opening DLL.
The references are set properly and new code written using the above syntax cause Dr Watson to create a log file and kills Access as soon as I type the period for the .whatever
Thanks!<font face="Comic Sans MS">Morgan Erickson</font face=comic>
<img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>-From <img src=/S/flags/Colorado.gif border=0 alt=Colorado width=30 height=18> but living in <img src=/S/flags/Missouri.gif border=0 alt=Missouri width=30 height=18>...and working in Kansas.