Excell for Mac Microsoft Visual Basic Invalid procedure call or argument

Question

Hello friends! I have an issue while opening the macro Excel sheet on my Mac.

During an attempt to open an Excel doc, an

"Invalid procedure call or argument" error message pops up. By pressing OK button this message appears again and again.

I have to use force quite otherwise there is no other way how to escape from this error and close the program. A macro document has been created on Windows. I would appreciate it if you could advise me on how to solve this issue. Thank you beforehand.

Answer 1

Hello.

Many thanks for your detailed advice.

Unfortunately, I have been swamped the last few days and did not check the code and everything because it is not urgent for me now.

Anyway, thanks for your concern.

Answer 2

Well, I was sorta hoping you'd try my advice to open the Visual Basic Editor and have a look at the code. Some people look at VBA code and can figure out what it's doing simply by starting at the top and reading down line-by-line. Other people see only gobbledegook. I was waiting for your reaction. Another thing I was hoping to find out is whether the code has been encrypted. You would have complained about it wanting a password, if that were the case.

If you know what the code was supposed to do you might be able to write your own code and bypass the broken code.

If all this coding stuff is too tough, then I'd suggest posting the question to the MrExcel.com message board. You will find some professional coders there who might be able to troubleshoot the code, but perhaps for a fee.