GeorgeDurkee
Programmer
I have an MS Access program that reads data based on months and exports it to Excel. Since I need three months at a time, I run thru the routine three times.
The first time works fine. However, the second time, the same line that worked fine stops working, with a property not supported error.
The line is xlsheet.Zoom = 75. I've tried activewindow.zoom, windows.zoom and windows(1).zoom. The first two generate the property not supported error and the last gives a subscript out of range error.
The Help ystmeonly gives examples using activewindow or for page setup formatting (That works by the way, each time)
Any ideas what I'm doing wrong?
The first time works fine. However, the second time, the same line that worked fine stops working, with a property not supported error.
The line is xlsheet.Zoom = 75. I've tried activewindow.zoom, windows.zoom and windows(1).zoom. The first two generate the property not supported error and the last gives a subscript out of range error.
The Help ystmeonly gives examples using activewindow or for page setup formatting (That works by the way, each time)
Any ideas what I'm doing wrong?
