Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Device I/O Error | Excel Discussion (Misc queries) | |||
Device I/O Error | Excel Discussion (Misc queries) | |||
Device I/O Error | Excel Programming | |||
Device I/O Error | Excel Programming | |||
Device I/O Error | Excel Programming |