Using the SaveAs in VBA

[caldog]

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

[Gary''s Student]

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.
--
Gary''s Student


"caldog" wrote:

> 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

[caldog]

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?

"Gary''s Student" wrote:

> 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.
> --
> Gary''s Student
>
>
> "caldog" wrote:
>
> > 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