JazzSP8
Well-known Member
- Joined
- Sep 30, 2005
- Messages
- 1,227
- Office Version
- 2013
- 2010
- Platform
- Windows
Hey All
I'm trying to use VBA in Excel 2003 to export a file as a CSV but with a TXT file extension.
So after some messing about I came to the conclusion that the best idea would be to create the CSV file as I normally would do and then simply rename the ".csv" as ".txt" which I can do no problem in DOS but I'd like to finish the job properly in the Macro.
Only problem being I don't have a clue how to do that from within VBA
Ideally if someone could point me in the right direction of the VBA equivalent of the DOS
that would be great
Thanks in advance for any help that can be provided.
I'm trying to use VBA in Excel 2003 to export a file as a CSV but with a TXT file extension.
So after some messing about I came to the conclusion that the best idea would be to create the CSV file as I normally would do and then simply rename the ".csv" as ".txt" which I can do no problem in DOS but I'd like to finish the job properly in the Macro.
Only problem being I don't have a clue how to do that from within VBA
Ideally if someone could point me in the right direction of the VBA equivalent of the DOS
Code:
ren *.csv *.txt
Thanks in advance for any help that can be provided.