Syntax Help To Run application in other workbook

[modytrane]

I have a macro that Leith had helped me with.
It finds a directory [using wildcard] and a file within the directory.
Once I have the file open, I would like to Run a macro in that xls file.
I am attaching the macro below with a couple of styles of Application.Run statement, and I have tried a few different CALL statements.

The file [workbook] opens, but the Macro doesn't run.

Any help appreciated.
Thanks,
modytrane

Please Login or Register  to view this content.

[royUK]

Wouldn't it be easier to have the email macro more universal & save it as an addin, in the workbook that you are using or in PERSONAL.xls

[modytrane]

Roy,
This macro is part of a project that involves updating a number of project files with financial data downloaded into an excel file. The project files to be updated are on the local network drive. My program first creates a list of projects that need to be updated this month [based on report from home office], than goes to the network and opens each file.

Then I wanted to Run an application in each file, this macro would update the file and automatically send out an email to sales people involved in that project.

Right now the admin person opens each file manually, updates [with a button I've created] and hits a send_email button to send out email.
I am trying to automate this last part.

I want to keep the send_email macro withing each workbook, so if someone from another office accesses the workbooks, thay can hit the send_email button on the worksheet and run the same macro.



thanks,
modytrane