Hello everyone my name is Maurizio
And my problem is this:
On an Excel sheet from the Column ("A2: A32") I manually enter the dates of the month which I then want to export to a Txt File
While in Column ("C2: C32") I created a Routine that copies the dates of Column (A) to column (C) if necessary
Now the things he wants to get are these:
1) because when I save the file (TXT) in my Subfolder, it is not classified as a Text File; But simply File.
2) the dates I was able to get once saved in the file; have this feature ("01/01/2022")
While I Wish They Were Reported In This Precise Way:
, 01/01 / 2022,02 / 01/2022 ,, As Final Date.
According to you it is possible to achieve all this
Thanks for all the help you want to give me on this
Greetings from A.Maurizio
<img alt="1° Image" src="""[Image Can Not Be Found]" /> <img alt="2° Image" src="""[Image Can Not Be Found]" />
<img alt="3° Image" src="""[Image Can Not Be Found]" />
Hi Maurizio,
I don't know if this work, but try to enter also the ending in your VBA
eg:
FileName = "/File_Txt/1_txt/DATANAME.txt"
I found something in the internet, what hopefully can help you:
linkHello Trias
thanks for your advice I tried it and now it works as I wanted from the beginning
Thanks Greetings and Good Evening from A.Maurizio
