03-23-2005, 07:50 PM
I have a macro that opens a report off a web site, copies the data to excel and then closes the report web page. It does this process 19 times using 2 functions.
The problem is that I receive the window not found error at different times in the macro. Sometimes I can run the macro through 17 of the reports. The next time I run the macro I can only get through 3 reports. Run it again and get through 15 of the reports.
I am trying to figure out why I receive this error and why at different times. Any ideas of what to look for?
I have slowed the macro done to spe 500.
I close the report window by name.
I always re-activate the menu window prior to selecting the report.
Thanks for any help.
The problem is that I receive the window not found error at different times in the macro. Sometimes I can run the macro through 17 of the reports. The next time I run the macro I can only get through 3 reports. Run it again and get through 15 of the reports.
I am trying to figure out why I receive this error and why at different times. Any ideas of what to look for?
I have slowed the macro done to spe 500.
I close the report window by name.
I always re-activate the menu window prior to selecting the report.
Thanks for any help.