Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs Method changes Worksheet Name
I am using the following code in a form running from a Macro in Exce 2002: filesavename = Application.GetSaveAsFilename("", _ fileFilter:="CSV Files (*.CSV), *.csv") If filesavename < False Then MsgBox "Save As " & filesavename End If ActiveWorkbook.SaveAs filesavename, FileFormat:=xlCSV The workbook saves as a new CSV file but changes the name of the activ sheet. What can I do about this? Thank -- nmager ----------------------------------------------------------------------- nmagerl's Profile: http://www.msusenet.com/member.php?userid=161 View this thread: http://www.msusenet.com/t-187045632 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem using SaveAs method | Excel Discussion (Misc queries) | |||
SaveAs Method changes Worksheet Name | Excel Programming | |||
A little help with SaveAs Method please | Excel Programming | |||
Difficulties with SaveAs method | Excel Programming | |||
SaveAs method | Excel Programming |