Hello all, I assumed wrong what was causing the issue and had another thread changing how my values were copied to the sheet.
My issue is that the code below is outputting a text file with many rows of blank lines after the last line of text. Is there a way to remove the extra lines when it is saved?
Thanks in advance!
Please Login or Register to view this content.
Last edited by silentcarl; 04-01-2015 at 08:10 AM.
I am so very close. Now my issue is saving the workbook. I want to use SaveCopyAs rather then SaveAs, but I get an error with the way I am using it.
Please help!
Please Login or Register to view this content.
I am trying to:
1. Copy a rng
2. create new temporary sheet
3. Paste data to new sheet
4. save the active sheet (i assume a copy is the right way) as txt file
5. leave my original workbook as the active sheet
6. delete the new temporary sheet
If I do a simple SaveAs, it works, but the whole workbook is titled the new name and then I close it in the code and my old workbook is not open any longer.
This works.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks