Run Excel Macro

[DavidCAllen]

Good Morning

Some assistance please. I am trying to run a Macro which is currently within Personal.xls, on an excel document that I am opening via a loop through each file in a folder. My current task is as:

Start Loop "Each File in C:\Tasks\BB"
If $Extension$ Equal to "xls" Then
Open "$CurrentDirectory$\$FileName$.$Extension$"
Excel: Run Excel Macro "BB45".Session: Default
End If
End Loop

The error I get is that AA cannot find the Macro BB45 with the Session name Default, I have tried a Session Name of PERSONAL, with the same result.

I have tried opening the Personal.xls via Open Spreadsheet command before the loop, this then has the effect of the Macro running on the Personal.xls workbook rather than the file opened by the loop.

Many thanks

David

[DavidCAllen]

Have resolved my problem, by using the keystrokes comand instead of the Run Excel Macro, having assigned a Hot Key to the macro.

Used a wildcard for the Excel session of *Excel*.

Would still be intrested in knowing if there is a solution useing the Run Excel Macro, command.

Many thanks

[trentonponder]

It looks like you're trying to run a Macro stored in an Excel Personal Macro Workbook.

I've also had problems with the particular feature. Only macros stored directly in the file you're trying to edit will work, try it on a file named something other then Personal.