Using Outlook to run a script

[wolfdemon710]

Hi guys,

I wrote a VBA on outlook which basically saves an attachment into a folder and then runs a vba code in another excel file that is saved in that folder also. However, it only runs the first vba in the second excel file. For simplicity, i have two codes in the second excel file, first is output Test in cell and then second code is create a new excel workbook and save it in the folder also.

here is the outlook code:

Please Login or Register  to view this content.

Here is the code for second excel file

Please Login or Register  to view this content.

Why doesnt my outlook code run both these macros?

[skywriter]

Double posted.

[pjwhitfield]

You'll need to put your code in [Code] tags to meet forum standards.

In the meantime though, why are you calling AddNewWorkbook2 twice? You're calling it in the Outlook code but also at the end of the TestOpen sub

[skywriter]

It's also double posted, see my post above yours.

You'll need to put your code in [Code] tags to meet forum standards.

In the meantime though, why are you calling AddNewWorkbook2 twice? You're calling it in the Outlook code but also at the end of the TestOpen sub

[wolfdemon710]

Hi,

I have added the code tags and i edited the other posts and said solved. Sorry new to the forum.

Sorry i have edited the code, it should be calling from the outlook file, not the TestOpen sub.

[skywriter]

I have added the code tags and i edited the other posts and said solved. Sorry new to the forum.

Thanks.

I don't see anything obvious. Have you tried putting the word stop in your code so it will stop it and then stepping through it line by line to see what's happening.

I'm also curious are you calling this:
Public Sub saveAttachtoDisk(itm As Outlook.MailItem)
from some other code not shown? I ask because you have a parameter in between the () but I don't see you calling this procedure in the code you posted. I'll admit I have no experience with Outlook code but in the Sub Application_StartUp() I would put a Stop in there to see what happens on the lines where you are using Application.Run and then step through the code.

[wolfdemon710]

Hey,

Thanks for the reply. I tried and steped through the code, but it just go through the step without any errors but the vba isnt run. :S So confusing.

[skywriter]

If you want help then you need to be specific. Stepping through code without errors means the VBA did run.
So where are you starting, what happens at each step, when you call a sub does it jump to that other sub, do all the lines in the other sub run?
You also didn't answer the question I asked you in my last post.