Saving specific sheet as CSV UTF-8

[MasterBash]

Hi,

I currently have this code :

Attaching the file file test.xlsb

Please Login or Register  to view this content.

Please Login or Register  to view this content.

What it does is save my Data sheet in CSV without the header row (first row). Everything works fine, except that I wish to change it to CSV UTF-8. Unfortunately, as it is currently I am unable to use the file unless I save it manually as CSV UTF-8.

Also this part is optional but it would be nice to have. When I click the button - It opens a dialog box prompting to choose the folder to save the file as. The filename is inside the C2 cell, so it will save as C2value.csv . The second part is fine, because if I want to create a dynamic filepath, I can do that and simply type in the path that I want to use (A2 as an example, but it will be replaced with a formula). However, if I want to create a dynamic filepath, I would like to make to be able to easily remove the dialog box (comment out), because there will be no point in selecting the folder if the path is chosen automatically... I don't like the current implimentation because it doesn't allow me to see files in the folder, only folders.

How can I edit my current code... or I can just replace my current code with something more efficient, to accomplish what I am trying to do ?

Thank you !

[sudbhavani]

Try this code

Please Login or Register  to view this content.

[MasterBash]

I had a chance to thoroughly test it out yesterday and today. It works really well. Thank you !

[sudbhavani]

thanks for you repu

[bakerman2]

Absolutely nothing wrong with sudbhavani's code but since you are using a Table for your data I'd suggest you use the Table Object Properties to determine rows and columns to write csv lines.

Please Login or Register  to view this content.