Invoke VBA, text file only?

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 :grinning:

@MikeC

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

Hope this helps

Cheers

Hi,

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

Thanks

@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

1 Like

Glad we cleared that up :joy:

Thanks Anil :ok_hand:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.