Excel is not saving while trying to run in Uipath

Help Studio
, ,
1

i have multiple excel file which is in .xlsx.iam automating that multiple excel files using vba code after successful formating it not saving showing

image
image543×178 22.5 KB

The image shows the Macro Settings menu in the Trust Center of Microsoft Excel, where "Enable VBA macros (not recommended; potentially dangerous code can run)" is selected along with options to enable Excel 4.0 macros and trust access to the VBA project object model. (Captioned by AI)
The image shows the Macro Settings menu in the Trust Center of Microsoft Excel, where "Enable VBA macros (not recommended; potentially dangerous code can run)" is selected along with options to enable Excel 4.0 macros and trust access to the VBA project object model. (Captioned by AI)805×658 8.6 KB

i enabled in trust center but still showing that prompt

2

Hi @Vijayan_Sathyagiri_EXTERN,

Could you try saving the file in .xlsm format, maybe it could work.

3

i dont need in .xlsm format i need in .xlsx format
Thankyou

4

@Vijayan_Sathyagiri_EXTERN,

What activities you are using for this?

5

The image shows a UI of a programming tool utilizing a Try Catch block within an Excel Application Scope to run a VBA script named "Formatting.vba" and the macro "KeepColumnsByNamesInPlaceAndCopyData". (Captioned by AI)
The image shows a UI of a programming tool utilizing a Try Catch block within an Excel Application Scope to run a VBA script named "Formatting.vba" and the macro "KeepColumnsByNamesInPlaceAndCopyData". (Captioned by AI)390×424 12.1 KB

6

@Vijayan_Sathyagiri_EXTERN,

Try using Modern activities Excel Process Scope → Use Excel File → Invoke VBA

Also the macro code file should be a text file.

Like this:

The image displays an "Excel Process Scope" workflow in an automation tool, utilizing an Excel file and invoking a VBA script. (Captioned by AI)
The image displays an "Excel Process Scope" workflow in an automation tool, utilizing an Excel file and invoking a VBA script. (Captioned by AI)586×772 32.4 KB

7

The image depicts an RPA (Robotic Process Automation) environment interface where a VBA (Visual Basic for Applications) script is being invoked to perform an Excel-related task, with output and error details shown. (Captioned by AI)
The image depicts an RPA (Robotic Process Automation) environment interface where a VBA (Visual Basic for Applications) script is being invoked to perform an Excel-related task, with output and error details shown. (Captioned by AI)1354×752 49 KB

8

@Vijayan_Sathyagiri_EXTERN,

  1. Open notepad
  2. Put your vba code in a text file
  3. Pass this file path to Code file path
9

same issue iam facing while debugging in visual studio code also

10

@Vijayan_Sathyagiri_EXTERN,

If excel macro settings are done now, try restarting the system once.

11

Found the solution
Thankyou
@ashokkarale
in vba Code i disable the code line ws.open and ws.close
Dont need to open the excel and close the excel

1 Like
12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.