Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filename parameters passed based on cell contents
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. Reply » |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create filename based on cell contents | Excel Worksheet Functions | |||
Filename based on Cell contents | Excel Programming | |||
Macro to Save As with filename based on cell contents. | Excel Programming | |||
Create filename based on cell contents | Excel Programming | |||
Extract parameters passed to a function. | Excel Programming |