MS Excel VBO

[mark.haynes]

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
------------------------------

[NicholasZejdlik]

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

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

[MarcoMatuttis1]

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
------------------------------

[ewilson]

@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
------------------------------