VBA QUESTION

  • Thread starter Thread starter luar
  • Start date Start date
L

luar

I have a problem with a program that I created in VBA,
this program after doing all calculations it saves the
results on sheets within the same workbook, but it
converts this sheets in to .TXT files on a different
directory. Whwn it's done Excel remembers the last of this
files, is there a way to make the program save as the
original file wish was in (.XLS)
thank you
 
Just before creating the txt files, save the workbook. Creating the
textfiles does a saveas, so the original workbook still exists. You can
have your code reopen it at the end.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Help with copying a sheet from One workbook to another workbook 1
Hiding an Excel file using VBA 1
SAVE A SHEET AS A BOOK, CLOSE IT, CONTINUE VBA CODE - XCL 2003 16
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Where to store VBA code for executing against xls in email? 5
Lose macros before saving 4
vba instruction for file saving 5

Back
Top