Macro with .xlsm extension not being accepted by UiPath

excel
activities
macro
p_qa

#1

I’m trying to execute a Macro with UiPath. For do so I’m using an Excel Application Scope with the name of the Excel file that contains the macro code, that means that this file has an .xlsm extensión. Inside of the Excel Application Scope I’m using the activity Execute Macro.

However, UiPath pops an error when reacing the Excel Application Sope activity and trying to open the .xlsm Excel File (“This extensión can not be used with the selected file type. Change the file extensión in the File name text box or select a different file type by changing the Save as type”).

Can someone help me with this issue?

Thanks a lot!


#2

Hi There,

I just ran into the same issue and I was wondering whether you found any solutions. Thanks in advance.

Regards,
Ani


#3

I’m looking for a solution for this as well!


#4

I think your office/excel installation blocks the xlsm files. Is it working if you open the same file, manually in Excel?


#5

Yes, it works when opening the .xlsm file manually. But when executing the robot, and it reaches the point where it has to treat the file, pops up the alert window.


#6

Hi, Did we have any solution to this? Facing the same issue.
Execute macro Faulted
Execute macro : VB projects and XLM Sheets cannot be saved in a macro-free workbook.


#7

Hi,
The error means that the type of excel book is not macro type… Try to open the file again and ‘Save As’ the file as macro type (.xlsm).

If issue still persists, please come back with error screenshot and/or sample file.

Best Regards,
Santosh Pothina


#8

Yes , it worked fine. Thanks Santosh.


#9

Hi Guys Can anyone help me with the below error message.

This extension can not be used with the selected file type. Change the file extension in the File name text box or select a different file type by changing the Save as type.

Here we are using the macros but the Macro.
So its an automation related issue or business?

Thanks.
Chandra.


#10