Save as macro

From: Logan (anonymous_at_discussions.microsoft.com)
Date: 03/10/04


Date: Wed, 10 Mar 2004 10:14:32 -0800

I would like to create a macro that would take the
information from two different cells and use them as the
file name, then save the file as an .xls in another folder.

The cells I would like to use are named, Surname and
filenumber.

I am then going to create a command button on the toolbar
so that all the employees have to do is click the 'Save As'
button.

I have no problem with creating the shortcut bottons and
assigning the macro to it. It just that I am very new to
VBA and not sure how to write the code, for the save as part.

Any help would be appreciated