VBA syntax to repair corrupted file

[dpaton05]

I need some help with some vba syntax. I have part of a procedure that opens another workbook, performs some actions then closes it. This is the code I have:

Workbooks.Open (ThisWorkbook.Path & "\" & DocYearName)

All the workbooks are stored in the same folder and the variable DocYearName contains the file name of the workbook to be opened. I have had a heap of trouble with workbooks being corrupted and I have no idea why they are being corrupted.

How do I incorporate repairing a corrupted file into this command?

 

[Macropod]

I have had a heap of trouble with workbooks being corrupted and I have no idea why they are being corrupted.

Instead of trying to work around the issue, you should sort it out at the source.

 

[Michael M]

@Macropod
Already suggested stepping through with F8 to see if it works manually first.....then maybe look at a wait line, if it does !!!

 

[Macropod]

So, in effect, this is a duplicate of the discussion already underway in: https://www.mrexcel.com/forum/excel...workbooks-failed-post5278543.html#post5278543

dpaton05: Kindly don't start new threads duplicating topics you already have under discussion. See: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html. Thread closed. You may continue the discussion in your original thread.