Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
save as text crashes Tom Ogilvy
If this is true then why does the "Indesigndate.txt workbook name appear on
the sspdate.xls workbook sheet1? Open a textfile in excel using File=Open. Notice that there is only one worksheet and it has the same name as the file. This is just the way excel operates - a textfile has no provision for saving sheet names, formatting and other stuff associated with a workbook. Generally workbooks "crash" because our code does something it shouldn't -- Regards, Tom Ogilvy "Janis" wrote: 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? gt; "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. gt; 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? gt; thanks, Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
save as text crashes Tom Ogilvy
sspdate.xls
appears to be an xls file. It can have any name you want to give it as long as it has a legal construct. Or are you saying you opened a textfile named sspdate.xls (text file, not excel file) and the single sheet had the name Indesigndate.txt? If you are saying that, then you are indeed the owner of a very special version of excel. this is the way it happens for me: ? activeworkbook.Name dir.txt ? activeworkbook.Worksheets(1).name dir -- regards, Tom Ogilvy "Janis" wrote: If this is true then why does the "Indesigndate.txt workbook name appear on the sspdate.xls workbook sheet1? Open a textfile in excel using File=Open. Notice that there is only one worksheet and it has the same name as the file. This is just the way excel operates - a textfile has no provision for saving sheet names, formatting and other stuff associated with a workbook. Generally workbooks "crash" because our code does something it shouldn't -- Regards, Tom Ogilvy "Janis" wrote: 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? gt; "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. gt; 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? gt; thanks, Thank you |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
save as text crashes Tom Ogilvy
I think I figured out the answer, the .txt save is first. If I do the xls
save first it doesn't do it. THANKs,. "Janis" wrote: If this is true then why does the "Indesigndate.txt workbook name appear on the sspdate.xls workbook sheet1? Open a textfile in excel using File=Open. Notice that there is only one worksheet and it has the same name as the file. This is just the way excel operates - a textfile has no provision for saving sheet names, formatting and other stuff associated with a workbook. Generally workbooks "crash" because our code does something it shouldn't -- Regards, Tom Ogilvy "Janis" wrote: 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? gt; "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. gt; 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? gt; thanks, Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel crashes on save | Excel Discussion (Misc queries) | |||
save as text crashes | Excel Programming | |||
save as text crashes | Excel Programming | |||
Hi Mr. Ogilvy how to Ctl+s to save workbook from Active UserForm | Excel Programming | |||
Save As... crashes Excel | Excel Programming |