Save as macro
From: Logan (anonymous_at_discussions.microsoft.com)
Date: 03/10/04
- Next message: Frank Kabel: "Re: Macro delete rows"
- Previous message: Frank Kabel: "Re: Multiple copy cells downwards"
- Next in thread: J.Smith: "Save as macro"
- Reply: J.Smith: "Save as macro"
- Reply: Logan: "Save as macro"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: Frank Kabel: "Re: Macro delete rows"
- Previous message: Frank Kabel: "Re: Multiple copy cells downwards"
- Next in thread: J.Smith: "Save as macro"
- Reply: J.Smith: "Save as macro"
- Reply: Logan: "Save as macro"
- Messages sorted by: [ date ] [ thread ]