Using the SaveAs in VBA

[Guest]

I want my end users to not lose the master worksbooks, that they have. So
how do I have them save say five worksbooks as one file name, thereby not
touching the original workbook.

Now I'm a novice at coding in VBA, so please explain so that a novice can
understand.

Example say I have these workbooks:
Room & Board.xls
SOC.xls
Refunds.xls
TimeSheet.xls

What I want to see is the above four workbooks save as say September 2005.xls

Thanks

Steve

 

[Guest]

Create a master workbook. Then in VBA activate each workbook and copy each
sheet into the master workbook with a Sheets.Copy command. The save the
master.

Try it with a small sample using the Macro Recorder to get the correct syntax.

 

[Guest]

Thanks Gary, but I don't think that will work for me.

Let me try to explain what I need. I have these four workbooks-see below
for names-each month my end users are going to open each book and put data
into these books. At the end of the month, what I would like for them to be
able to do is save their work in all four workbooks as one file,thereby not
distrubing the original workbooks. BTW each workbook is a stand alone one.
What I would like the end user to be able to from my menu page is to click on
a button-have the system ask them for a name to name all these workbooks as
one file. Is this possible?