Macro generates the following error: "run-time error 424 object required"

I am receiving the error listed above for the following script.

Please Login or Register  to view this content.

Any help would be appreciated.

Thanks,

Met

Thanks for everyones input. (The code is being modified by itself.) I will need to approach this a different way. I know I am going aroung the world to do a simple task but I can't see the forest for the trees, I guess.

My goal: Auto log into a Add-in in an Excel file.

Here is where I stand:

I created a batch file to open excel. (If I open excel with a vbs file it does not load the Add-Ins.)

Please Login or Register  to view this content.

I created a script file to run a macro created in the excel file:

Please Login or Register  to view this content.

Then I run the macro: (It runs the add-in)

Please Login or Register  to view this content.

It runs the addin to a point but the login menu will not open until my macro closes so I was going to load another script, close the macro, and then use the other script to fill in the prompt which I hope will appear after the macro within Excel has closed. I'm sure I've confused the hell out of everyone by now but humor me if you have any suggestions.


Thanks,

Met