Invoke Code-Application is missing

Help Studio
, ,
1

The image shows a Visual Basic for Applications (VBA) script for reading an Excel workbook in read-only mode, saving it as a writable file with a new path, and then closing the workbook and quitting the Excel application. (Captioned by AI)
The image shows a Visual Basic for Applications (VBA) script for reading an Excel workbook in read-only mode, saving it as a writable file with a new path, and then closing the workbook and quitting the Excel application. (Captioned by AI)958×563 30.5 KB

Hello,

I am trying to execute the above code but i am getting the error.
Please let me know whats wrong in this activity

The image shows a screenshot of UiPath Studio with an error message indicating that the type 'Application' is not defined, suggesting the need to add an Activity Package to the workflow. (Captioned by AI)
The image shows a screenshot of UiPath Studio with an error message indicating that the type 'Application' is not defined, suggesting the need to add an Activity Package to the workflow. (Captioned by AI)484×388 63.2 KB

3

Hello @sharu_priya,

Try this code.

Screenshot 2025-01-02 113002
Screenshot 2025-01-02 113002861×600 10.5 KB

4

Thank you so much.

It worked. But as soon as the excel is opened after run/debug, i am getting this pop up.

A pop-up window is prompting for a password to gain write access or offering the option to open a file named 'R&D 9-23.xlsx' as read-only. (Captioned by AI)
A pop-up window is prompting for a password to gain write access or offering the option to open a file named 'R&D 9-23.xlsx' as read-only. (Captioned by AI)534×291 5.49 KB

How to handle this

5

If you’re working with code:

  1. Open the file in read-only mode (no password needed).
  2. If you must edit, you’ll need the password.
6

Client will not provide the password.So we are giving save as and saving the excel for the edit access.

For that only, i used new file path

7
  1. Read the File (Read-Only Mode):

a. Drag and drop the Excel Application Scope activity.
b. Set the file path (e.g., "R&D 9-23.xlsx").
c. Check the ReadOnly property.

  1. Save As New File:
  • Inside the Do block of Excel Application Scope, add an Invoke VBA activity with the following script:

rep
rep538×142 3.36 KB

  • Provide the VBA script path and file to run it.
  1. Reopen the New File for Editing:

a. After saving the file, use another Excel Application Scope to open the new file (e.g., "R&D 9-23_Edit.xlsx") without enabling ReadOnly.

8

Its invoke code or invoke VBA

The image shows the "Invoke VBA" activity with fields for "Target workbook," "Code file path," "Entry method name," and "Output" in an automation software interface. (Captioned by AI)
The image shows the "Invoke VBA" activity with fields for "Target workbook," "Code file path," "Entry method name," and "Output" in an automation software interface. (Captioned by AI)918×638 23.3 KB

I did not understand this point " * Provide the VBA script path and file to run it."

9

Use this.

1.
1.526×156 2.28 KB

rep
rep538×142 3.36 KB

This is a set of instructions for using the "Excel Application Scope" and "Invoke VBA" activities within a workflow to automate saving an Excel file with a new name. (Captioned by AI)
This is a set of instructions for using the "Excel Application Scope" and "Invoke VBA" activities within a workflow to automate saving an Excel file with a new name. (Captioned by AI)1156×354 10.8 KB

10

I have enabled this but still getting this error.

This image shows a message window detailing how to enable the "Trust Access to the VBA project object model" setting in Excel through the Trust Center. (Captioned by AI)
This image shows a message window detailing how to enable the "Trust Access to the VBA project object model" setting in Excel through the Trust Center. (Captioned by AI)753×482 11.9 KB

11

can you send your code??

13

Excel Rename.zip (6.6 KB)

14

excel sheet not there

15

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