topic Re: Open Excel Workbook changes file name in Product Forum

Open Excel Workbook changes file name

Erika_Papp — Mon, 28 Aug 2023 10:19:37 GMT

Hi All,

There is a strange behavior in the Blue Prism MS Excel VBO Object.

In some cases the Open Workbook action OUT Workbook Name parameter changes the original file name:

From _Rebate --> _rebate

Please help what could cause this issue.

Re: Open Excel Workbook changes file name

DevendranVenkatesh — Tue, 29 Aug 2023 11:47:49 GMT

Dear Erika,

This is strange, Even I have created a test excel with name of "3302116_Spinnaker_ZTE_VZ_20230701-0731_Rebate" and its working fine.

Please confirm which version of blueprism are you using it?

Re: Open Excel Workbook changes file name

harish.mogulluri — Tue, 29 Aug 2023 20:20:25 GMT

Hi Erika,

I would suggest to download the latest VBO and check whether you observe the same behavior

https://digitalexchange.blueprism.com/dx/entry/3439/solution/ms-excel-vbo

Re: Open Excel Workbook changes file name

DevendranVenkatesh — Tue, 05 Sep 2023 12:52:11 GMT

Dear Erika,

Still are you facing the same issue?

Re: Open Excel Workbook changes file name

Erika_Papp — Tue, 05 Sep 2023 13:41:44 GMT

Hi Devendran,

We are using Blue Prism 7.1.0.

I had to change the process immediately as the error caused a lot of exception.

To get the workbook name I use the split path option instead of using Blue Prism Excel VBO Open Workbook output parameter.

I have only logs where this strange behavior can be investigated.

Re: Open Excel Workbook changes file name

Babjee24 — Wed, 06 Sep 2023 06:37:40 GMT

Hi Erika,

Is this happening with this specific excel or is it the same for all?

If this is specific to this excel then the issue is with the file create a new excel with same naming and copy all the data into new file and try reading it.

Re: Open Excel Workbook changes file name

DevendranVenkatesh — Wed, 06 Sep 2023 08:53:06 GMT

Dear Erika,

Thanks for your update. Please reimport latest excel VBO and copy & paste all the data's into new excel and then do a test and confirm us back.

Based on the outcome we will move forward. thanks