Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filename created by passing parameter of cell values
I have posted this in the general Excel discussion group but it might
be better here. Hello, Has anyone experience with passing cell parameters to a file name using a button and VB? I have a spreadsheet I am using to send out to multiple individuals to collect data and need a consistent format to help manage the files that I will be receiving via email. Here is what I have in mind: There are three cells containing data that I would like to concatenate into a file name for my spreadsheet. The filename would end up being something like: cell1_cell2_cell3_date.xls. Finishing the data entry, the user would click on a button within the spreadsheet, then click on the OK button in the SaveAs window. The next step would involve code that emails the spreadsheet as an attachement (this is done already). We are all on the same version of Outlook and Excel so compatibility is not an issue. Any ideas? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filename created by passing parameter of cell values
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
passing parameter to a ms query | Excel Programming | |||
Passing chartobject as a parameter to sub | Excel Programming | |||
Passing a Sub's name as parameter | Excel Programming | |||
Passing parameter to a query | Excel Programming | |||
Passing a parameter to Excel | Excel Programming |