Saving files
I have a workbook that has a macro that does a save as
saves a csv file. The problem is that until you close
the file and re-open it, it still has formuals, multiple
worksheets, etc in it. For my purposes, I need the file
to be a true csv file.
Is there a way to do a file save as and close that file
with out closing the current excel file. OR save the
current file as an excel file then save as again as a csv
file then open the excel file and close the csv file.
To complicate it more the file is opened originally as a
read only and I would have to come up with some type of
name for the save.
Any help will be greatly appreciated.
Cindy.
|