Method 'Run' of object '_Application' failed

Hi All,

I have the following code, which is giving me the error: "Method 'Run' of object '_Application' failed" on this line:

Please Login or Register  to view this content.

I am trying to call a function from another spreadsheet after populating it with some data.

Does anyone have any thoughts on why I might be getting the error message?

Thanks!!

Please Login or Register  to view this content.

I think you're going to have to open the other workbook before running the macro.

So you shouldn't include the path; you're referring to the opened workbook, not the workbook on disk.

Are you sure the macro name is correct? What is the declaration line of the macro/function and where is it located? (i.e. in which module?)

There should be an apostrophe before the exclamation mark in your macro name.

Glad to help. Please don't forget to mark the question 'Solved'.

Question: i am getting Error: Method 'Run' of object '_Application' failed.

Please Login or Register  to view this content.

i would like to know the why i am getting error? anything wrong with code please let me know.

You need to open the workbook before you try to run the macro.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.