Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Device I/O Error JMay Excel Discussion (Misc queries) 4 October 5th 09 02:24 AM
Device I/O Error jason Excel Discussion (Misc queries) 0 December 3rd 04 01:28 PM
Device I/O Error RJH Excel Programming 1 August 19th 04 08:39 AM
Device I/O Error RJH Excel Programming 2 August 1st 04 04:00 AM
Device I/O Error Seth[_3_] Excel Programming 0 July 8th 03 05:58 PM


All times are GMT +1. The time now is 11:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"