topic RE: MS Excel VBO in Product Forum

MS Excel VBO

mark.haynes — Thu, 12 Mar 2020 09:44:00 GMT

Hello,

I'm using the standard MS Excel VBO, opening a workbook, checking some details and adding data to a row and then saving into another location, the spreadsheet contains some dates, which open in UK format, (Added Local:=True to Open Workbook code) but when the workbook is saved to the new location it is saving the dates in the an American format, which causes problems later in the process, is there a way of setting it to save the dates in Local format?

Thanks

------------------------------
Mark Haynes
Automation Developer
------------------------------

RE: MS Excel VBO

NicholasZejdlik — Fri, 13 Mar 2020 14:01:00 GMT

There is a similar Local parameter when saving the workbook, setting that to true might help.

------------------------------
Nicholas Zejdlik
RPA Developer
------------------------------

RE: MS Excel VBO

MarcoMatuttis1 — Wed, 10 Nov 2021 09:30:00 GMT

Can you please share the Code that you have been using. Especially where in the Excel VBO you added these Local=True Parameter

------------------------------
Marco Matuttis
Robot Process Automation Developer
INTER Krankenversicherung AG
Mannheim
------------------------------

RE: MS Excel VBO

ewilson — Wed, 10 Nov 2021 15:17:00 GMT

@Mark Haynes,

As @Nicholas Zejdlik pointed out, you would need to update whichever action you're using to save the Workbook to include the Local:=True option too. As an example, if you're using the Save Workbook As action, you change the VB in the Code stage from wb.SaveAs(filename) to something like wb.SaveAs(FileName:=filename, Local:=True).

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------