Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro - File Save As
I'm using the macro below to save a file after clicking a button to
certain cell value. I've moved the start file to a different folder but the saved version go back to the old one. I can't figure out wh that is based on the info in the macro. Sub SaveAs() Dim a_str1 As String Dim sname As String a_str1 = ActiveSheet.Cells(5, 2).Value sname = Trim(a_str1) + Trim(b_str1) + ".xls" ActiveWorkbook.SaveAs Filename:=sname, _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=Fals -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Macro to Open File, Delete Contents, Save New File | Excel Discussion (Misc queries) | |||
Macro Save File (Unique file name) | Excel Worksheet Functions | |||
Macro to insert values from a file and save another sheet as a .txt file | Excel Programming | |||
Automate open file, update links, run macro, close and save file | Excel Programming | |||
HOw do you save a file using a macro? | Excel Programming |