LinkBack URL
About LinkBacks
Hello
I have set up the following macro that when you click on convert to csv it converts the fields. The issue i have is I want to fix the columns date to format as MM/DD/YY when I click on the button 'convert to csv'.
how would i do this?
Hello
I have set up the following macro that when you click on convert to csv it converts the fields. The issue i have is I want to fix the columns date to format as MM/DD/YY when I click on the button 'convert to csv'.
how would i do this?
Just add
Formula:
Please Login or Register to view this content.
immediately before the .SaveAs instruction
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.
Where would you add that code?
Perfect thank you
just noticed it does not work. it appears to not save anything else in the spreadsheet when i press the convert to csv
My mistake all working now
Your code does not include anything which populates the myCSVFileName variable.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks