| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro syntax "Save As" with filename from cell ref.
Hi, I'm looking for a macro syntax that allows me to SAVE AS with
number copied from a cell reference. (see below "PASTE HERE FROM COPY") Thanks in advance / Magnus .............. Application.Goto Reference:="R1C1" Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False Selection.Copy Application.CutCopyMode = False ActiveWorkbook.Save ActiveWorkbook.Close ActiveWorkbook.SaveAs Filename:=PASTE HERE FROM COPY, FileFormat:=xlNormal _ , Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=False End Sub |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro syntax "Save As" with filename from cell ref.
Is it the activecell? If so
ActiveWorkbook.SaveAs Filename:= activecell.text -- -John Please rate when your question is answered to help us and others know what is helpful. " wrote: Hi, I'm looking for a macro syntax that allows me to SAVE AS with number copied from a cell reference. (see below "PASTE HERE FROM COPY") Thanks in advance / Magnus .............. Application.Goto Reference:="R1C1" Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False Selection.Copy Application.CutCopyMode = False ActiveWorkbook.Save ActiveWorkbook.Close ActiveWorkbook.SaveAs Filename:=PASTE HERE FROM COPY, FileFormat:=xlNormal _ , Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=False End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| a Macro to "save as" filename from a cell on the sheet and then pr | Excel Discussion (Misc queries) | |||
| "CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
| Save active sheet as "filename" on a remote server with username and password | Excel Programming | |||
| Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions | |||
| Automatically include contents of a cell in "Save As..." filename. | Excel Programming | |||
Linear Mode
