Save Excel worksheet as csv

[JeremyRTDean]

Newbee question so an example would be helpful...

I'm looking for an action that saves a populated Excel worksheet as a .csv file.

I expect I need to extend the existing VBO Excel SaveWorkbookAs action which uses the code:
wb.SaveAs(filename)

to somehow use the VB parameter:

xlCSV

Any tips on how I do that (or more specifically, the syntax)?

------------------------------
Jeremy Dean
------------------------------

[VanithaK]

Hi,

We were using MS office 365 Proplus and for xlCSVUTF8 = 62 to save the excel into CSV.

But now same code is not working for MS Office 2016 Professional Plus.

Can you please help us what should be used here. And after saving it, we are reading the CSV and writing it into CSV as UTF8 using Write Text file as UTF8.