Invoke VBA, text file only?

[MikeC (Mike)]

Hi Guys,

Just checking that within the activity Invoke VBA " Code file path " has to be a text file ?
Does it / can it accept the PERSONAL.XLSB ?

Thanks

[Anil_G (Anil Gorthi)]

@MikeC

For that you can use execute macro or run macro activity…instead of invoke vba activity…

Hope this helps

Cheers

[MikeC (Mike)]

Hi,

Yes im aware of that, was asking if the invoke accepts the PERSONAL.XLSB ?

Thanks

[Anil_G (Anil Gorthi)]

@MikeC

Yes you can …instead of the macro name directly you have to give it this way

”‘C:\Users\username\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB’!MacroName"

This is generally the personal.xlsb path

Cheers

[MikeC (Mike)]

Glad we cleared that up

Thanks Anil