Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to save as using two cell values inside worksheet
I want to create a macro to rename a file at the first save using th value of two cells inside the workbook -- sdblac ----------------------------------------------------------------------- sdblack's Profile: http://www.excelforum.com/member.php...fo&userid=1469 View this thread: http://www.excelforum.com/showthread.php?threadid=26318 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to save as using two cell values inside worksheet
With ThisWorkbook.Worksheets(1)
ThisWorkbook.SaveAs filename:= _ "C:\MyFolder\" & .Range("A1").value & "_" & _ .Range("B9").Vaue & ".xls" End With You said the first save - but it would be hard to suggest much more without knowing more about the workbook - is it being created from a template, when the values in the two cells would be created and so forth. -- Regards, Tom Ogilvy "sdblack" wrote in message ... I want to create a macro to rename a file at the first save using the value of two cells inside the workbook. -- sdblack ------------------------------------------------------------------------ sdblack's Profile: http://www.excelforum.com/member.php...o&userid=14694 View this thread: http://www.excelforum.com/showthread...hreadid=263180 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Text with Carriage Returns inside cell values | Excel Discussion (Misc queries) | |||
How to Count values inside a cell when refered elsewhere? | Excel Worksheet Functions | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
macro save a file name from a cell in 1st worksheet | Excel Discussion (Misc queries) | |||
Macro Inside Cell | Excel Discussion (Misc queries) |