Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro to save as a data input by user file name from a designated
I have a macro that will save the workbook prior to deleting all specified
cells but I'm trying to make it save as file name of what ever the user inputed into a specified cell or cells like the date that they input and another cell that they inputfor like name of etc..... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro to save as a data input by user file name from a designated
Maybe this will give you a start:
with thisworkbook .saveas filename:=.worksheets("sheet1").range("a1").value & "\" _ & .worksheets("sheet999").range("b999").value & "\" _ & format(worksheets("sheet1000").range("d323"), "yyyymmdd") _ & "somemoretext here" & ".xls" end with Brian wrote: I have a macro that will save the workbook prior to deleting all specified cells but I'm trying to make it save as file name of what ever the user inputed into a specified cell or cells like the date that they input and another cell that they inputfor like name of etc..... -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro to save as a data input by user file name from a designated
Brian wrote: I have a macro that will save the workbook prior to deleting all specified cells but I'm trying to make it save as file name of what ever the user inputed into a specified cell or cells like the date that they input and another cell that they inputfor like name of etc..... Brian wrote: I have a macro that will save the workbook prior to deleting all specified cells but I'm trying to make it save as file name of what ever the user inputed into a specified cell or cells like the date that they input and another cell that they inputfor like name of etc..... -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening a file with User Input | Excel Discussion (Misc queries) | |||
User Data Input | Excel Worksheet Functions | |||
Disallow File Save if No Input in Cells? | Excel Discussion (Misc queries) | |||
Macro for user to input 10 numbers | New Users to Excel | |||
Macro to pause for user input in dialog box | Excel Discussion (Misc queries) |