How to change default path for personal.xlsb file in uipath

[gitesh.bhoir]

Hi Team,

I am trying to run personal macro from UiPath but UiPath giving error that personal.xlsb file is not available or exists. The reason behind that is UiPath searching personal.xlsb file by default in user\document folder.
can someone help me how to change this default path to wherever I want.

Following is the screenshot shows how I am trying to execute the Macro.

[Palaniyappan (Palaniyappan P)]

@gitesh.bhoir

The reason behind that is UiPath searching personal.xlsb file by default in user\document folder.

Whenever you are trying to run a macro with EXECUTE MACRO activity then the specified excel file must be macro enabled and I could see you have mentioned as .xlsx

Is it .xlsx file or xlsm or xlsb

Please validate that once

Or

Try calling in this way

Execute Macro from Personal Macro Workbook

Hi all, I am trying to use the Execute Macro activity to run a macro from my Personal Macro Workbook (PERSONAL.XLSB), but I encounter an exception, which I’ve included below. My input field for Execute Macro is as follows, where “JobsheetExport” is the macro name: “C:\Users\Daniel\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB!JobsheetExport” Here’s part of the error message (if the full message helps, I can post that too): Message: The range does not exist Source: Execute macro Ex…

Cheer @gitesh.bhoir

[gitesh.bhoir]

yes it is because i need to performed macro operation on latest downloaded file, which can not be macro enabled.
right now if I placed Personal.XLSB file in document folder macro getting executed successfully.
But I don’t want to keep this file in document folder instead I have to keep this in project directory, So I need to find out the way to change the default path where UiPath is looking this Personal Macro file.

[Palaniyappan (Palaniyappan P)]

@gitesh.bhoir

Personal.XLSB file in document folder macro getting executed successfully.
But I don’t want to keep this file in document folder instead I have to keep this in project directory, So I need to find out the way to change the default path

Well we can browse for the file location from the excel activity itself and take the file from project directory itself

@gitesh.bhoir

[gitesh.bhoir]

Thanks @Palaniyappan. but I am able to fixed this issue by keeping this Personal.xlsb file in document folder( which is default path for UiPath/Blueprism). I need to change that.

[Palaniyappan (Palaniyappan P)]

Fine

What is the current folder path and what you want to change in that

Pls share this folder path you have
@gitesh.bhoir

[gitesh.bhoir]

As I mentioned its user\Documents, I need to change it to project directory.
But not sure from where and how i can change this in UiPath.

[Palaniyappan (Palaniyappan P)]

@gitesh.bhoir

As I mentioned its user\Documents, I need to change it to project directory

Fine
You mean you want to keep the file directory in the project folder where main.xaml files are like placed

In that case move that file to project directory
And mention just the FileName like this while passing the input in the macro activity
\yourfilename

Cheers @gitesh.bhoir