
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