open workbook - timeout function?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
Would be grateful for any help.
One of the .xls files on my PC is probably corrupt as I am unable to open it
either manually or using the worksheet.open command. however, it doesn't
"fail" - it just keeps on trying. Is there anyway I can detect this/create a
time-out and let it fail nicely?

Thanks in advance
 
A neat trick you can try when recovering a corrupt worksheet is to us
the Data-Import function to import it into a new worksheet. This ha
worked quite successfully for me in the past but with no guarantees
Good luck
 
Thanks for your help, I shall remember that. Unfortunately the user wont
know in advance which files are corrupt, so I would have to resort to this
method as a default.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What are the steps to fix damaged MDF files in SQL Server? 0
All Workbook Saved except This Workbook 3
All Workbook Saved except This Workbook - Part2 3
Run code from another workbook 7
Workbook which having unreadable contents is not getting opened 1
Copy sheet from workbook in new instance of Excel 3
trying to email workbook from VB6, getting error 1004 2
What kind of workbook function should I used? 1

Back
Top