Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i save an excel spreadsheet from a captured cell?
I would like to save an excel workbook using a specific captured cell from
that worksheet? So when i go to save a workbook it will capture the information from cell D5 (for example) and use that info as its file name. Is there a way of doing this? In word when you go to save a document for the first time it will automatically save it as the first few words written in the document. Can this be done with excel? And can it be specified to a particular cell in the worksheet? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i save an excel spreadsheet from a captured cell?
you can save as a cell reference, though this would require programming code.
Set up so that it loks liek the below. Change C:\ to wherever you'd want it to save and Range("A1") to the range you want to use as your save as filename. ActiveWorkbook.SaveAs Filename:= _ "C:\" & Range("A1") & ".xls", FileFormat:=xlNormal, _ Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=False "luke-sushi" wrote: I would like to save an excel workbook using a specific captured cell from that worksheet? So when i go to save a workbook it will capture the information from cell D5 (for example) and use that info as its file name. Is there a way of doing this? In word when you go to save a document for the first time it will automatically save it as the first few words written in the document. Can this be done with excel? And can it be specified to a particular cell in the worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts are captured between rows and show up in powerpoint | Charts and Charting in Excel | |||
How can I keep my cursor from being captured in excel? | Excel Discussion (Misc queries) | |||
save Excel spreadsheet as XLS or XML? | Excel Discussion (Misc queries) | |||
My hyperlink in an excel spreadsheet will not save. | Excel Discussion (Misc queries) | |||
How do I plot data in Excel that is captured on separate sheets; . | Excel Discussion (Misc queries) |