VBA: Device I/O error (Error 57)

[Laurent Schwärzler]

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

 

[Jakeman]

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

 

[Laurent Schwärzler]

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