Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveWorkbook.SAVEAS for *.xls
I want to save a file in the 2003 version in the name of value of a cell.
What might be wrong with: Sub SAVEAS() ActiveWorkbook.SAVEAS "D:\New Folder\" & _ Range(Application.InputBox("SELECT", , , , , , , 8)).Text & ".xls", _ FileFormat:=xlExcel9795 End Sub Your comments and guidance shall be appreciated. -- Best Regards, Faraz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
saveas ActiveWorkbook.SaveAs Filename:=Range("A1").Value | Excel Programming | |||
ActiveWorkbook.SaveAs | Excel Programming | |||
Help with ActiveWorkbook.SaveAs | Excel Programming | |||
ActiveWorkbook.SaveAs | Excel Programming | |||
activeworkbook.saveas | Excel Programming |