Hi everyone
I hope someone here is able to help me, cuz I haven't succeed in finding the right way myself.
I have made some macros helping me to save data as txt file .
But, when I run the macro to save the data into a txt file (I have used below macros it automatically changes all "," into "."
Please help how automatically changes all "." into "," ( on amount)
Please Login or Register to view this content.
Last edited by kirana2014; 06-15-2021 at 02:42 PM.
Hi,
I'm somewhat confused
I temporarily changed my Windows regional settings to match your Netherlands settings where the decimal separator is a comma and the file opens to show the numbers like 21,25 and not the 21.25 that you show in the picture.
The eventual text file produced shows 21.25 whether I use the Dutch or UK settings
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Re: Decimal separator changes when save data to a txt file
Originally Posted by kirana2014
Hi,
just add to the SaveAs statement its Local parameter set to True …
Dear Marc,
Please help how to Add SaveAs statement its Local parameter set to True
Re: Decimal separator changes when save data to a txt file
As it's like its CreateBackup parameter so you can do it …
I try below but not working
Please Login or Register to view this content.
Sub Save_txt()
Sheets("data").Select
Sheets("data").Copy
ChDir "C:\Wayan Data"
ActiveWorkbook.SaveAs Filename:="C:\Wayan Data\test123.txt", FileFormat:= _
xlText, Clocal:=True
ActiveWorkbook.Close
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks