Answer the question
In order to leave comments, you need to log in
Why is there an error in the macro?
You need to open a damaged excel through a macro.
Google says - use XlCorruptLoad.xlRepairFile parameter
Can't figure out how to use it?
I start to enter the parameter, put a dot at the end, then he himself suggests choosing the parameter value.
Choose:
But.. Error:
What's wrong?
Answer the question
In order to leave comments, you need to log in
The error indicates that the symbol =
was expected
Try the following solution:
Dim oWbk As Workbook
Set oWbk = WorkBooks.Open("C:\mybook1.xls")
Bold indicates what you are missing.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question