[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| Title: | Microsoft Excel User Hints and Kinks |
|
| Moderator: | FIEVEL::FILGATE |
|
| Created: | Thu May 27 1993 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 483 |
| Total number of notes: | 1391 |
473.0. ""XLQUERY.XLA problem" by JGO::KLAASSE () Wed Mar 05 1997 10:02
Hello,
Hope someone can help me on this one.
Iam using a macro in V5.0 that copies sheets created in various other
macro's into a new book.
When running the macro the following error-message pops-up:
Macro error at cell:
[XLQYERY.XLA]XLQUERY!B797
After the error-message I took the following steps:
- Copied XLQUERY.XLA from a colleque into the Libary.
- Via tools/add-ins activated \libary\XLQUERY.XLA
After doing this I ran the macro again. Eureka it works !
Next day run the macro again, the same error pops-up.
Activated XLQUERY.XLA via tools/add-ins again and everything works fine.
Any help is appriciated
Regards,
Ron Klaasse
| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 473.1 | how about | CHEFS::16.37.8.213::Mad | you poor mis-guided fools | Mon May 12 1997 08:09 | 5 |
| Try adding the below to the bigging of the macro
AddIns("MS Query Add-In").Installed = True
Mad
|