Dear Friends, I need to convert excel to .binary and i have decided to use invoke vba activity for that. The following is my code: Sub saveExcel(XlsbFilePath) MsgBox (XslbFilePath) ActiveWorkbook.SaveAs XslbFilePath, FileFormat:=50 Application.DisplayAlerts = False End Sub And this is how i …

Hi @NazAutomate , In your VBA code, the parameter you are passing to the subroutine is “XlsbFilePath”, but you are using another variable named “XslbFilePath” to pass it’s value to ‘SaveAs’ method and msgbox. Please try using same variable name in your entire VBA program, which doesn’t care about t…

How to pass file path variable value in invoke VBA

Help

NazAutomate (Nazarius) September 29, 2019, 9:31pm 3

Dear @nimin ,

OMG!!! Stupid mistake and you spotted it right away. Thank you bro, I changed it and it worked perfectly.
Please people, do not stop helping each other. xD

Kr,

Naza

1 Like

Topic		Replies	Views
Passing Variable using through Invoke VBA activity Help activities , variable , question	14	5725	June 18, 2022
Invoke VBA - error in parameters Activities excel , activities , question	4	1954	June 10, 2022
Excel Macro Code issue Forms studio , macros	10	1798	December 22, 2021
Using VBA and file name excel variables Activities excel	13	1154	April 14, 2023
Set Variable On VBA Import Text to Excel Studio excel , studio , question , vba , invoke-vba	4	792	April 6, 2023

How to pass file path variable value in invoke VBA

Related topics