Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Save As" cell reference in a macro
I am looking for a way to create a macro that would save
a file according to a cell reference. This could include a cell within a worksheet, or the Title field in the Properties menu. Any information would be extremely helpful. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Save As" cell reference in a macro
Hi
try the following 8using cell A1 from sheet 1) sub save_it() dim wks as worksheet dim fname Dim path set wks = worksheets("sheet1") path = "C:\Temp\" fname=CStr(wks.Range("A1").value) ActiveWorkbook.SaveAs Filename:=path & fName end sub -- Regards Frank Kabel Frankfurt, Germany jreiv wrote: I am looking for a way to create a macro that would save a file according to a cell reference. This could include a cell within a worksheet, or the Title field in the Properties menu. Any information would be extremely helpful. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Save As" cell reference in a macro
Hey....You,
See my reply to Mike D above. It sound like an evolution similar to the example I gave him. You can apply Cell.Value to retrieve cell contents or populate a variable. Matthew =} -----Original Message----- I am looking for a way to create a macro that would save a file according to a cell reference. This could include a cell within a worksheet, or the Title field in the Properties menu. Any information would be extremely helpful. . |
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) | |||
Macro to Insert Current Date into cell - Macro to "Save As" | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
"Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) |