Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using the output of a formula to name a workbook or sheet
I have a template which I use each week to produce a new workbook.
I name the weekly workbook with a week number generated by a formula dependent on the date of the calculation. How can I "capture" the output of the formula and use it within a Macro to name the workbook each week? Jonathan Grodzinski ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using the output of a formula to name a workbook or sheet
Public Sub SetWorkbookName()
ThisWorkbook.SaveAs Filename:="C:\myfolder\" & format( _ Worksheets(1).Range("A1").Value,"00") & ".xls", _ fileformat:=xlWorkbookNormal End Sub -- Regards, Tom Ogilvy Jgrodz wrote in message ... I have a template which I use each week to produce a new workbook. I name the weekly workbook with a week number generated by a formula dependent on the date of the calculation. How can I "capture" the output of the formula and use it within a Macro to name the workbook each week? Jonathan Grodzinski ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help getting output value from another sheet | Excel Discussion (Misc queries) | |||
Hyperlink to another sheet within a workbook using formula | Excel Worksheet Functions | |||
Bring one sheet from one workbook to another via formula | Excel Discussion (Misc queries) | |||
how can I paste to a different workbook without formula refrencing the original sheet | New Users to Excel | |||
How to output recordset data to sheet | Excel Programming |