I like this macro it does what I want and its easy to understand. It closes
book1.xls as the original. It saves two copies one as a text file. The
other one remains open. The only problem is on the one that remains open,
the new ssp....xls file, it renames (sheet1) as the Indesign....txt file.

Since I use sheet1 in the next macros to do some formatting, I got around
that by naming it as a collection.
With ActiveWorkbook.Worksheets(1)
instead of
With activeworkbook.workseets(sheet1)
But I wonder why it changes the name of the sheet to the name of the first
file that was saved. Its a little weird and it crashes I think more than
not. Maybe I am better off doing the save a different way?

thanks,

With activeworkbook.workseets(sheet1)
I assume this was a typo on your part, but I thought Worksheets("Sheet1")
was the generic name for sheet 1 no matter what else you use for the public
name. Am I wrong?

"Janis" wrote:

I like this macro it does what I want and its easy to understand. It closes
book1.xls as the original. It saves two copies one as a text file. The
other one remains open. The only problem is on the one that remains open,
the new ssp....xls file, it renames (sheet1) as the Indesign....txt file.

Since I use sheet1 in the next macros to do some formatting, I got around
that by naming it as a collection.
With ActiveWorkbook.Worksheets(1)
instead of
With activeworkbook.workseets(sheet1)
But I wonder why it changes the name of the sheet to the name of the first
file that was saved. Its a little weird and it crashes I think more than
not. Maybe I am better off doing the save a different way?

thanks,

Maybe its okay, I just ran it again and it didn't crash. But I've noticed
the personal workbook gets corrupted a lot. I have to make sure that it
isn't a recovered one I'm working on. That seems to be when it crashes.

In any case, this macro I mentioned needs to save a text file. So I am in
the original file
and I have to save two files in order to get it to save a text file.
Otherwise it can't use saveas. It saves a text file names
indesigndate&time.txt. It also saves the original file as sspdate&time.xls.
This ssp...txt file has the name of the indesign...txt file as the first
sheet.

The original file closes unchaged. This new xls file is left open as I said
with the sheet1 name changed. I can still proceed with other process macros
by changing them to act on sheets(1) as a collection instead of using the
"sheet1" name because the name is no longer sheet1.

I wish I knew why my personal workbook keeps crashing. I think I need to
build in some error trapping. any suggestions are helpful.

"JLGWhiz" wrote:

With activeworkbook.workseets(sheet1)
I assume this was a typo on your part, but I thought Worksheets("Sheet1")
was the generic name for sheet 1 no matter what else you use for the public
name. Am I wrong?

"Janis" wrote:

I like this macro it does what I want and its easy to understand. It closes
book1.xls as the original. It saves two copies one as a text file. The
other one remains open. The only problem is on the one that remains open,
the new ssp....xls file, it renames (sheet1) as the Indesign....txt file.

Since I use sheet1 in the next macros to do some formatting, I got around
that by naming it as a collection.
With ActiveWorkbook.Worksheets(1)
instead of
With activeworkbook.workseets(sheet1)
But I wonder why it changes the name of the sheet to the name of the first
file that was saved. Its a little weird and it crashes I think more than
not. Maybe I am better off doing the save a different way?

thanks,