Save an Excel worksheet with a generated filename

[MattHarvey]

I am running an application in Excel Office 2000. The application is used by an end user (the customer) and I want to save the file under a filename by asking the customer to input their surname and date of birth and use this as the filename. Ie. a pop up box asking the customers to input these details.

Can you suggest the code in Visual Basic that I can assign to a command button that will do this?

(The application produces a quotation and I wish to save the quotation for future reference using the surname & DOB to locate it.)

 

[Jallamann]

Hello Matt
Are you familiar with VBA?
the simplest thing to do is to show the user a popupbox, as you say. This can be done in two ways: either by using the inputbox function, which limits you to one inputfield, or create a userform with as many fields as you like. Put the return from these inputboxes into a variable, which you use as an argument on the workbooks .saveas method. Email me if you want an code example

Best Regards
Morten Starvik
morten.starvik@egroup.no
ASP manager
Egroup Online
Norway