I see your point of confusion. My Access application creates a spreadsheet and performs a procedure to reformat and reposition fields on this spreadsheet. After the spreadsheet is opened by my application, if I then close the spreadsheet, the following line in my Access application is...
The following procedure works fine the 1st time I run the procedure. This procedure reformats an Excel spreadsheet.
When I RERUN the procedure, then after I close the spreadsheet, the compiler stops with the following line highlighted:
For Each Cell In Range(xlWS.Cells(1, 16), xlWS.Cells(65536...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.