OUTLOOK: VBA error no 5 invalid procedure call

[dita_dk]

I have recently shifted from Office 2010, to Office 2013, however my macro, which i use from Outlook is not working anymore.
The functionality is extracting data from the Calendar, to Excel.

Error message is as in subject title. Error No: 5; description: Invalid procedure call or argument

VBA Code will be posted below

 

[dita_dk]

Re: VBA error no 5 invalid procedure call

By changing to your second, i got Run-time error '-2147221020 (800401e4)
Automation error

And by changing to example 1, i got a compile error

 

[dita_dk]

Re: VBA error no 5 invalid procedure call

You would get that error if Excel is not already running.

Error comes both with and without Excel running

 

[dita_dk]

Re: VBA error no 5 invalid procedure call

Error comes both with and without Excel running

No, only with Excel closed, this error comes. But the other error still persist, even with excel open.
In office 2010 the macro did start Excel it self, but not here?

 

[RoryA]

Re: VBA error no 5 invalid procedure call

Which line causes the other error when Excel is already open?

 

[dita_dk]

Re: VBA error no 5 invalid procedure call

When Excel is opened manually before activating the script, i get this error 5, invalid procedure call.

Debugging end up at line:
AppActivate "appExcel"

 

[RoryA]

Re: VBA error no 5 invalid procedure call

That should really be:

AppActivate appExcel.caption

 

[dita_dk]

Re: VBA error no 5 invalid procedure call

That should really be:

AppActivate appExcel.caption

Awesome - now it works

Anybody who can solve the problem that causes an error, when you dont open Excel, before running the macro ?

 

[RoryA]

Re: VBA error no 5 invalid procedure call

If you re-enable the error handler it should work.

 

[dita_dk]

Re: VBA error no 5 invalid procedure call

If you re-enable the error handler it should work.

Exactly.
I'm new to this forum - thank you for support
it is appreciated