Hello all,
I have a VBA excel(2003) reports that are scheduled to run every night. They began returning #value! in the results in August. I've been looking over the set-up and code but have not found anything obvious.
Let me also mention that the code is about 5 years old and was written with Office 2000 installed. I don't know when the Office 2003 upgrade happened.
The reports pull from an InSQL db running Active Factory software residing on the same server as the code. Here are some snipits of things I've found in the worksheet itself that I'm not following:
"%%=wwQuery("SCADA2",B79)" -I don't know what the %%=wwQuery means. I've looked under Data/Import External Data/Edit Query and it is greyed out. SCADA2 is the name of the server.
Any guidance/advice on where else to look or something else to try?
Thanks for your help,
Ang
I have a VBA excel(2003) reports that are scheduled to run every night. They began returning #value! in the results in August. I've been looking over the set-up and code but have not found anything obvious.
Let me also mention that the code is about 5 years old and was written with Office 2000 installed. I don't know when the Office 2003 upgrade happened.
The reports pull from an InSQL db running Active Factory software residing on the same server as the code. Here are some snipits of things I've found in the worksheet itself that I'm not following:
"%%=wwQuery("SCADA2",B79)" -I don't know what the %%=wwQuery means. I've looked under Data/Import External Data/Edit Query and it is greyed out. SCADA2 is the name of the server.
Any guidance/advice on where else to look or something else to try?
Thanks for your help,
Ang
