M
M
Max Trophy2018-05-23 17:06:05
Macros
Max Trophy, 2018-05-23 17:06:05

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:
5b05753342996198153292.png
But.. Error:
5b05753a678fd630544784.png
What's wrong?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
shushpanio, 2018-05-23
@kapitoly

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 question

Ask a Question

731 491 924 answers to any question