Forum

Get Dates with only...
 
Notifications
Clear all

Get Dates with only the leading and trailing commas for each cell

3 Posts
2 Users
0 Reactions
64 Views
(@a-maurizio)
Posts: 214
Reputable Member
Topic starter
 

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]" />

 
Posted : 08/09/2022 3:44 am
(@trias)
Posts: 3
Active Member
 

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:

link
 
Posted : 10/09/2022 3:36 am
(@a-maurizio)
Posts: 214
Reputable Member
Topic starter
 

Hello 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

 
Posted : 14/09/2022 11:42 am
Share: