Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As based on cell value
I would like to save a form based on the value of a cell
after I format it and before I email it and then revert to the presaved or "master". I am struggleing with the Save As part. This is what I have so far... Sheets("Data").Visible = False Sheets("Introduction").Select ActiveWindow.DisplayWorkbookTabs = False Range("C3:D3").Select ActiveWorkbook.SendMail "", _ "Your 2004 Flexible Benefit Election Form" Any suggestions anyone has will be greatly appreciated! Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As based on cell value
Presuming that file name is located in A1 here is what you
can try: Sub saveAsCellValue() ActiveWorkbook.saveAs ("C:\" & Sheets("SHEET1").Cells(1, 1).Value) End sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Results of a cell based on cell referenced in a cell | Excel Worksheet Functions | |||
SAVE & SEND A FILE BASED ON TEXT IN A CELL VIA MACRO | New Users to Excel | |||
save to folder based on cell value | Excel Discussion (Misc queries) | |||
enter data in cell but cannot save until click off cell in excel | Excel Discussion (Misc queries) | |||
Automatically save file based on cell value | Excel Discussion (Misc queries) |