Variable “XslbFilePath” is actually of string type which contains filepath where to save the file.
But it failed when runs, and I think the problem is, because my Entry method parameters not right.
Error message is:
Can you please tell me what is wrong?
Thank you for your help.
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 the one you used as parameter in UiPath.
Another reason for your issue may be with the filepath string you are passing. Use a write line activity to display the value of “XlsbFilePath” just before invoking VBA to make sure that you are using the correct File path with a proper format.
There is no issues with you EntryMethodParameter. You can also pass the argument along with method name like "'saveExcel("""+XlsbFilePath+""")'"
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