Export Excel xlsx to delimeted csv file - diffing tool on git

Hi Guys,

i am creating macro to export current xlsx file into delimated csv file to have diffing tool on bitbucket.

Screenshot_6.png

I want to export this in American US regional settings so they are using "." as decimal point.
What i have to do i have to go to regional settings in windows 10, change to US settings (because default are polish), go to Excel and saved a file as CSV.

Now when i switch to Polish regional settings and open csv i am sure that i have proper format:

Screenshot_7.png

Because now if Americans will open file - they will see screen like in first screen above (seperated columns format)

How can i do this? Can i export TableQuery or someting like this?
Please help,
Best wishes,
Jacek Antek

o wow Keebellah love your help and love this forum,
thank you very much.

Seems to be very complex task.
Creating text file hmm like new .txt?

It seems very difficult for me.
Best,
Jacek

hmm but i have to open notepad using code and replace from there.
The best option would be to take used range and loop and change decimal point somehow and export to txt file maybe?

Best,
Jacek

Originally Posted by jaryszek

I want to export this in American US regional settings so they are using "." as decimal point.

Please Login or Register  to view this content.

hi jindon,

you are genious!

thank you so much the very big issue was solved.
the only solution in internet it is use change regional settings.

Love you
Best,
Jacek

Keebellah thank you very much for support and help,

jondon solved the issue. Now i can save and it is in good format.

Best wishes for you!
Jacek