xytle
New Member
- Joined
- Apr 8, 2012
- Messages
- 6
Hi,
I'm still new to VBA and can't figure this one out. I work with txt files that I open with Excel (2010 on Windows). I need to accomplish the following steps:
1. Save the workbook as xlsx file, to the same location where the txt file currently was. No name change is needed, just the file type.
2. Copy the workbook as a new workbook and close the original one.
(On the copy, I'm running a short macro that renames columns. I already have that macro, just need to insert it at this point).
3. After that little macro, I need to save this new workbook as a txt file with a specific name: "OrangeLabels" to a folder named "VendorLabels" on my Desktop.
Hope someone can help me with this little puzzle.
Thanks!
I'm still new to VBA and can't figure this one out. I work with txt files that I open with Excel (2010 on Windows). I need to accomplish the following steps:
1. Save the workbook as xlsx file, to the same location where the txt file currently was. No name change is needed, just the file type.
2. Copy the workbook as a new workbook and close the original one.
(On the copy, I'm running a short macro that renames columns. I already have that macro, just need to insert it at this point).
3. After that little macro, I need to save this new workbook as a txt file with a specific name: "OrangeLabels" to a folder named "VendorLabels" on my Desktop.
Hope someone can help me with this little puzzle.
Thanks!