Save a Worksheet in Excel to a Master Workbook 
Author Message
 Save a Worksheet in Excel to a Master Workbook

Quote:

> Hi
> Can anyone supply the macro VB code to save a weekly excel worksheet to a
> Master Workbook?
> The worksheet is created weekly on my C: drive and I want to append each
> weekly sheet to the Master Workbook on the Network drive.
> Each Weekly Worksheet has a unique name, e.g Week 1, Week 2...etc This will
> result in the annual Workbook Master having 52 individual entries for the
> full year.

You'd be better off asking this in an Excel newsgroup.

--
Mike



Sun, 28 Aug 2011 03:56:20 GMT  
 Save a Worksheet in Excel to a Master Workbook
Have done so and got no reply. Hence asking here.
Quote:


> > Hi
> > Can anyone supply the macro VB code to save a weekly excel worksheet to a
> > Master Workbook?
> > The worksheet is created weekly on my C: drive and I want to append each
> > weekly sheet to the Master Workbook on the Network drive.
> > Each Weekly Worksheet has a unique name, e.g Week 1, Week 2...etc This will
> > result in the annual Workbook Master having 52 individual entries for the
> > full year.

> You'd be better off asking this in an Excel newsgroup.

> --
> Mike



Sun, 28 Aug 2011 04:50:08 GMT  
 Save a Worksheet in Excel to a Master Workbook

Quote:


>> > Hi
>> > Can anyone supply the macro VB code to save a weekly excel worksheet to a
>> > Master Workbook?
>> > The worksheet is created weekly on my C: drive and I want to append each
>> > weekly sheet to the Master Workbook on the Network drive.
>> > Each Weekly Worksheet has a unique name, e.g Week 1, Week 2...etc This will
>> > result in the annual Workbook Master having 52 individual entries for the
>> > full year.

>> You'd be better off asking this in an Excel newsgroup.

> Have done so and got no reply. Hence asking here.

You  probably won't get much help here either. For one, you don't write "macro code" using VB.  Secondly, we're not here to write
your code for you.  You post YOUR code which you're having problems with and we'll try and help with it.  Do you even have any
programming experience at all?

--
Mike



Sun, 28 Aug 2011 20:48:36 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. How can I open Excel workbook without using Excel.Worksheet

2. deleting worksheet in excel workbook

3. Word/Excel Insert Single Worksheet from Workbook

4. function to see if an Excel worksheet name exitsts in a workbook

5. processing excel rows - separate workbooks/worksheets

6. Excel - Use the current workbook and worksheet

7. detect the worksheet-names in an EXCEL 5.0 workbook

8. Excel Workbook vs. Worksheet

9. wsh/vba for excel automation: moving worksheets beetween workbooks

10. Accessing a worksheet in an Excel workbook

11. Help: nullreference exception when saving excel workbook

12. Saving Excel workbook w/o SaveAs dialog?

 

 
Powered by phpBB® Forum Software