Argument 'Workbook': BC30512: Option Strict On disallows implicit conversions from 'String' to 'IWorkbookQuickHandle'. The selected value is incompatible with the property type

Help Studio
1

Hi all,

I’m trying to convert a excel file (.xlsm) to save as and overwrite an .xlsm in another folder. When I’m using the “Save Excel File As” function, I get this error when trying to have to save the value to the new folder. I’m not sure where this error is coming from. Thank you in advance

“Argument ‘Workbook’: BC30512: Option Strict On disallows implicit conversions from ‘String’ to ‘IWorkbookQuickHandle’. The selected value is incompatible with the property type.”

The image depicts a software workflow with an error indicating a type mismatch for a property in an Excel workbook automation task. (Captioned by AI)
The image depicts a software workflow with an error indicating a type mismatch for a property in an Excel workbook automation task. (Captioned by AI)715×654 72.8 KB

image
image638×658 56 KB

2

Hi @jinson.buri

Could you try like below

  1. use excel file activity and provide excel variable FacCompRecent. This will generate excel workbook variable

  2. then inside it, use save excel file as and specify workbook variable created in step 1 under workbook instead of FacCompRecent.fullname

3

Hi thank you for the help. I believed I saved the workbook into the correctvarilable for FACompRecent. Unfortunately, I’m getting another error that states “Argument ‘WorkbookPath’: BC30456: ‘LastModifiedDate’ is not a member of ‘FileInfo’.”

Not sure how its not a member, I need to use lastmodifieddate to grab the latest updated excel file in the folder selected. Thank you

This image features a workflow tool interface for Excel file manipulation, displaying a configuration error related to the 'LastModifiedDate' property. (Captioned by AI)
This image features a workflow tool interface for Excel file manipulation, displaying a configuration error related to the 'LastModifiedDate' property. (Captioned by AI)720×741 60.6 KB

This image depicts a software workflow for handling Excel files, including actions to filter, save, and process files based on file attributes and configurations. (Captioned by AI)
This image depicts a software workflow for handling Excel files, including actions to filter, save, and process files based on file attributes and configurations. (Captioned by AI)557×752 66.9 KB

4

@jinson.buri,

To get last modified date, use this code

IO.File.GetLastWriteTime(yourFilePath)
1 Like
5

Hi @jinson.buri

As per your workflow, I see you are already selecting the last modified files from your folder, so why do you feel the need to do it again while providing workbook variable?

6

Correct, I took off the “Last Modified” and now I get a different message. The error is now listed as the following.

Argument ‘WorkbookPath’: BC30451: ‘FACompRecent’ is not declared. It may be inaccessible due to its protection level. Variable ‘WorkbookPath’ is missing. Please use Data Manager to recreate it.

This image shows an Excel file automation process error, indicating that a variable 'WorkbookPath' is not declared, alongside options for saving an Excel file as a macro-enabled workbook. (Captioned by AI)
This image shows an Excel file automation process error, indicating that a variable 'WorkbookPath' is not declared, alongside options for saving an Excel file as a macro-enabled workbook. (Captioned by AI)655×551 58.1 KB

The image illustrates an example workflow for processing Excel files in an automation task, including locating, modifying, and saving the files. (Captioned by AI)
The image illustrates an example workflow for processing Excel files in an automation task, including locating, modifying, and saving the files. (Captioned by AI)588×834 70.1 KB

7

@jinson.buri

I believe, under use excel file, it should be like FacCompRecent.FullName and not just FacCompRecent

Also, check to ensure you are using use excel file inside your for each as scope of variable FacCompRecent is inside that only.

8

@jinson.buri

Please see below, I am able to save excel file under different name following below.

The image shows a graphical user interface of a software automation tool configured for processing Excel files, including opening, modifying, and saving them. (Captioned by AI)
The image shows a graphical user interface of a software automation tool configured for processing Excel files, including opening, modifying, and saving them. (Captioned by AI)545×750 21.4 KB

9

Hi Sonali,

Thank you for the guidance. I entered “.fullname” and I still get the same message. I’m not sure where its stemming from.

The image depicts a screenshot of a workflow process in an automation software, showing operations involving filtering, utilizing, and saving Excel files with specified settings. (Captioned by AI)
The image depicts a screenshot of a workflow process in an automation software, showing operations involving filtering, utilizing, and saving Excel files with specified settings. (Captioned by AI)592×881 73 KB

A software interface displays an error regarding an undeclared argument 'WorkbookPath', with guidance to resolve the issue using Data Manager. (Captioned by AI)
A software interface displays an error regarding an undeclared argument 'WorkbookPath', with guidance to resolve the issue using Data Manager. (Captioned by AI)740×560 60.8 KB

10

@jinson.buri

Can you delete that workbook path from use excel file and then click on plus and then select that FAC variable from there instead of typing it in?

11

You don’t put .fullname on FACompRecent.

12

Hi! Yes, I was able to re-do the workflow following the appropriate steps and it was able to run it. Thank you

1 Like
13

Hi @jinson.buri

Glad to hear that :slight_smile:

Now that your issue is resolved, kindly mark the post that helped as a solution.

14

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