Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet Tab Name automatically changed. Why?
After using the Macro below, Sheet1 is re-named: 79601 ABC EDI RESUBS MACRO
I want the name of the tab to remain: Sheet1 Can someone tell me how I can fix this? Option Explicit Sub SaveAsTextFileInABCEDI_TodayFolder_SaveMacro() ' SaveAsTextFileInABCEDI_TodayFolder_SaveMacro Macro ChDir _ "C:\Program Files\Business Objects\BusinessObjects 5.0\UserDocs\ABC EDI\Today" ActiveWorkbook.SaveAs Filename:= _ "C:\Program Files\Business Objects\BusinessObjects 5.0\UserDocs\ABC EDI\Today\79601 ABC EDI RESUBS MACRO.txt" _ , FileFormat:=xlText, CreateBackup:=False ChDir _ "C:\Program Files\Business Objects\BusinessObjects 5.0\UserDocs\ABC EDI\1ABC Macros" ChDir _ "C:\Program Files\Business Objects\BusinessObjects 5.0\UserDocs\ABC EDI\1ABC Macros" ActiveWorkbook.SaveAs Filename:= _ "C:\Program Files\Business Objects\BusinessObjects 5.0\UserDocs\ABC EDI\1ABC Macros\79601 ABC EDI RESUBS MACRO.xls" _ , FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False End Sub -- Thank you so much for your help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet Tab Name automatically changed. Why?
The macro saves the file as a text file and the tab displayed when a text
file is open in Excel is the text file's root name -- Kevin Backmann "Dandelo" wrote: After using the Macro below, Sheet1 is re-named: 79601 ABC EDI RESUBS MACRO I want the name of the tab to remain: Sheet1 Can someone tell me how I can fix this? Option Explicit Sub SaveAsTextFileInABCEDI_TodayFolder_SaveMacro() ' SaveAsTextFileInABCEDI_TodayFolder_SaveMacro Macro ChDir _ "C:\Program Files\Business Objects\BusinessObjects 5.0\UserDocs\ABC EDI\Today" ActiveWorkbook.SaveAs Filename:= _ "C:\Program Files\Business Objects\BusinessObjects 5.0\UserDocs\ABC EDI\Today\79601 ABC EDI RESUBS MACRO.txt" _ , FileFormat:=xlText, CreateBackup:=False ChDir _ "C:\Program Files\Business Objects\BusinessObjects 5.0\UserDocs\ABC EDI\1ABC Macros" ChDir _ "C:\Program Files\Business Objects\BusinessObjects 5.0\UserDocs\ABC EDI\1ABC Macros" ActiveWorkbook.SaveAs Filename:= _ "C:\Program Files\Business Objects\BusinessObjects 5.0\UserDocs\ABC EDI\1ABC Macros\79601 ABC EDI RESUBS MACRO.xls" _ , FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False End Sub -- Thank you so much for your help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet Tab Name automatically changed. Why?
oh, Okay. I did not know that. thank you very much!
-- Thank you so much for your help! "Kevin B" wrote: The macro saves the file as a text file and the tab displayed when a text file is open in Excel is the text file's root name -- Kevin Backmann "Dandelo" wrote: After using the Macro below, Sheet1 is re-named: 79601 ABC EDI RESUBS MACRO I want the name of the tab to remain: Sheet1 Can someone tell me how I can fix this? Option Explicit Sub SaveAsTextFileInABCEDI_TodayFolder_SaveMacro() ' SaveAsTextFileInABCEDI_TodayFolder_SaveMacro Macro ChDir _ "C:\Program Files\Business Objects\BusinessObjects 5.0\UserDocs\ABC EDI\Today" ActiveWorkbook.SaveAs Filename:= _ "C:\Program Files\Business Objects\BusinessObjects 5.0\UserDocs\ABC EDI\Today\79601 ABC EDI RESUBS MACRO.txt" _ , FileFormat:=xlText, CreateBackup:=False ChDir _ "C:\Program Files\Business Objects\BusinessObjects 5.0\UserDocs\ABC EDI\1ABC Macros" ChDir _ "C:\Program Files\Business Objects\BusinessObjects 5.0\UserDocs\ABC EDI\1ABC Macros" ActiveWorkbook.SaveAs Filename:= _ "C:\Program Files\Business Objects\BusinessObjects 5.0\UserDocs\ABC EDI\1ABC Macros\79601 ABC EDI RESUBS MACRO.xls" _ , FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False End Sub -- Thank you so much for your help! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet Tab Name automatically changed. Why?
Kevin B wrote:
The macro saves the file as a text file and the tab displayed when a text file is open in Excel is the text file's root name I noticed that, too. Dandelo, perhaps if you reverse the order of the saves...First save as .xls, then as .txt, that would solve the problem. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlinks changed automatically in excel. | Excel Discussion (Misc queries) | |||
i want serial numbers should be changed automatically | Excel Discussion (Misc queries) | |||
How can I automatically highlight a cell that has changed value | Excel Worksheet Functions | |||
Automatically have the text changed when the value changes | Excel Discussion (Misc queries) | |||
How do I get a date changed automatically | Excel Worksheet Functions |