I have a VBA macro that catches data from website, copies it to a workbook, closes the temporary WB and goes back to the original WB. In order to automate the process, I use the sequence, when closing the WB:
.
Application.DisplayAlerts = False
ActiveWorkbook.Close
Application.DisplayAlerts = True
.
After working well for about 2 years, suddenly the little window asking whether or not I want to keep modifications to the tem WB shows again:
"Do you wish to save the modifications ? "
.
Logic:
1. Gets stock ticker from column "A"
2. Consults a stock website, which return a page with data
3. Searchs inside that page, does little change, gets the data
4. Copies data
5. Closes the temp WB, discarding changes
6. Writes data obteined to main WB
7. Loop
.
This is a repetitive process, more than 1.000 iterations. I need it fully automated, as it has been for 2 years, via the use of
Application.DisplayAlerts = False
.
My feeling is that I must have done something very wrong with Excel options or something - without noticing - for this to happen.
.
Any thoughts would be very much appreciated.
.
The WB is here, should someone cares to take a peek (less than 100KB):
.
http://rapidshare.com/files/18307731...ECOTA.zip.html
.
Comments in the VBA macro are in portuguese, but the code is standard, of course.
.
I also removed competely MS Office 2003 pt-BR and reinstalled, for no luck.
Thanks !
Bookmarks