| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As Macro
Thanks Bob it worked great
Bob Phillips wrote: You have the closing bracket in the wrong place sFilename = "C:\TimeSheet\" & _ Format(Range("h12").Value, "mm-dd-yy Job# ") & _ ActiveSheet.Range("h2").Value & " " & _ Range("b6").Value -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "ward376" wrote in message oups.com... Try changing the last .value to .formula. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Insert Current Date into cell - Macro to "Save As" | Excel Worksheet Functions | |||
| Macro (SAVE AS) | Excel Discussion (Misc queries) | |||
| Macro to Save without the Save Message | Excel Discussion (Misc queries) | |||
| ASP: Open Excel File with Macro, Allow Macro to run, and then save | Excel Programming | |||
| Prompted to save changes after macro save - why? | Excel Programming | |||
Hybrid Mode
