Execute Macro from another file

I am trying to execute a macro from a different file
In the execute macro I have typed the following and Btest is the macro name
“‘C:\Users\P1334857\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB’!Btest”

The error I am getting is
Execute Macro: Microsoft Excel cannot access the file ‘‘C:\Users\P1334857\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB’’. There are several possible reasons:

• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.

The below file exist
C:\Users\P1334857\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB

Hi @shanthi_solay !
Let’s try several options:

  • May you go to task manager and kill all excel processes, then run the code ?
  • Also, could you check if the user session that the bot uses has the access to the folder + the path ?
  • Could you check if when you copy paste the path C:\Users\P1334857\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB in your windows explorer here and hit enter does the file open ?

Yes. Killed all the excel process
From Windows explorer if i hit enter it is working.
Thanks for your reply.

Hi @shanthi_solay

  1. You are using excel application scope and inside it only execute macro is there.

  2. Give only the procedure name (Btest) as the file name is already given in the excel application scope.

Thanks