Solved: Sending arguments to macro in Personal.xls

[Marcster]

RE: http://vbaexpress.com/forum/showthread.php?t=7008


How do you pass arguments to the macro?
I've tried:

Run ("PERSONAL.XLS!RemoveAllVBACode(wb)")
Run ("PERSONAL.XLS!RemoveAllVBACode wb")

None work.

Set wb = ActiveWorkbook

The modue name in PERSONAL.XLS is:
ModRemoveAllVBACode


Thanks,

Marcster.

[TonyJollans]

Go for .. [VBA]Run ("PERSONAL.XLS!RemoveAllVBACode",wb)[/VBA](assuming wb is a variable)

[XLGibbs]

Run ("PERSONAL.XLS!'RemoveAllVBACode wb'")

Encapsulate both macro name and variable in ' tick marks..

Since they are in personal.xls you can also try

Call RemoveAllVBACode wb

[Marcster]

Sorted it:

Run "PERSONAL.XLS!RemoveAllVBACode", wb

Thanks,

Marcster.