VBA: Device I/O error (Error 57)
While opening a worksheet (containing a lot of VBA-Scripts of course), i was
informed of the error 57. I don't know whats happend, but since then i don't have a worksheet with all my VBA-code, but one without any code. After confirming the Messagebox, the worksheet opens, all data in the sheet is still here, but the macros are gone. Is there a possibility to read the macros without opening the worksheet Laurent |
VBA: Device I/O error (Error 57)
You need to clear up some space on your hard drive to open the file.
Try deleting files in your /Temp/ directory or clean out some Temporary Internet Files. Other than that, you could write a VBA routine in a seperate Excel file that would access the macros in your original Excel file and export/save them to a text file. Jake |
VBA: Device I/O error (Error 57)
Hi Jake
There is many space on the hard drive.... The second methode sounds interresting. I will try this. I hope i can access the file.... Thaks Laurent |
All times are GMT +1. The time now is 07:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com