microsoft.public.excel.programming

Don Guillett

12/12/2006 2:35:00 PM

see ans in other post.

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
<andy.crumbacker@gmail.com> wrote in message
news:1165933200.041031.3930@j72g2000cwa.googlegroups.com...
>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.
>