Excel Application Scope Error but It Doesn't Have This Error Before

[BBCC_0000]

Hi all,

I have encountered this error but don’t know how to solve.

Before this, it doesn’t have this error and can run smoothly.

Appreciate someone who can help me on this error. Thanks.

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

@BBCC_0000 Did you any quotation using inside the scope.Then,remove and enter it again.

[Yoichi]

Hi,

FYI, also check the following document.

Visual basic workflow compilation error

Hi, In windows legacy, it seems double quote is normalized and any double quote characer is accepted. However, at this time, in windows (.net6) ,in fact, only " (0x22) is accepted to express string literal. To make matter worse, it seems to occur only compiling. (Expression validator don’t raise an alert.) FYI, the following is sample for reproducing. The first Assign uses " 0x22 and second Assign uses “ and it fails in compiling. Sample20221013-2.zip (2.1 KB) [image] Regards,

Regards,

[Rahul_Unnikrishnan]

Hello @BBCC_0000

Have you migrated the project to windows from legacy recently?

The error seems to be because of some unwanted symbols. Can you try reselecting the excel again and if there are any double quotes provided, reenter again.

Thanks

[Gokul001 (Gokul Balaji)]

Hi @BBCC_0000

Can you try to re enter the file path in the activity. It is an Double quotation issue ""

Check out this thread

2022.10 Release is causing Compilation errors for Date conversions

Hi @Marco_Willigenburg Check the Double Quotation " in the Date Try with this expression "\kotvs003\KOT\Works\Poldat\Controlling\PBI\MPZW\InventoryPBI\Material Usage Per Month\Material Usage Per Month"+now.AddMonths(-1).ToString("MMyyyy")+".xlsx" Check out this thread Regards Gokul

Regards
Gokul

[BBCC_0000]

Yes, I have tried using double quotation as usual.

This is the behind of the code after the path:

DateTime.Now.ToString(“yyyyMMdd”) + “.xlsx”

It works before but not now, not sure why.

[Gokul001 (Gokul Balaji)]

Hi @BBCC_0000

@BBCC_0000

DateTime.Now.ToString(“yyyyMMdd”) + “.xlsx”

You need to enter the double quotation

Try with this expression

DateTime.Now.ToString("yyyyMMdd") +".xlsx"

[Gokul001 (Gokul Balaji)]

Give the Folder path of the File and try it @BBCC_0000

"C:\Users\Dell\Documents\UiPath\"+DateTime.Now.ToString("yyyyMMdd") +".xlsx"

[BBCC_0000]

Yes, I know. But the error still exists…

Does it need to set any variables? I remember it doesn’t need before.

[Gokul001 (Gokul Balaji)]

Hi @BBCC_0000

Can you share the screenshot of the activity and flow screenshot

[BBCC_0000]

Sorry to say that the project consists of some personal data.

I have modified the path, but it should be the same error when executing this activity.

[BBCC_0000]

[BBCC_0000]

[BBCC_0000]

Is it any quotation error? But before this I also follow this quotation format

[Gokul001 (Gokul Balaji)]

Can you share what is the error did you received?

[BBCC_0000]

I mean this one, same error, I just change the path as it consists of personal data, but the path formats are the same.

[Gokul001 (Gokul Balaji)]

Hi @BBCC_0000

Can you try to create the variable and pass the Variable in that activity and check it

[BBCC_0000]

What variable should I create?

[Gokul001 (Gokul Balaji)]

Hi @BBCC_0000

1. Use Assign activity

FolderPath = "C:\Users\Dell\Documents\UiPath\"+DateTime.Now.ToString("yyyyMMdd") +".xlsx"

2. In the Excel scope application use FolderPath

[BBCC_0000]

Hi, the code can be run now.

I think is the " and “ error.

Thanks everyone.