|
code
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Save a Worksheet in Excel to a Master WorkbookHi
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. Thanks for looking! Bobzter "Bobzter100" <Bobzter***@discussions.microsoft.com> wrote in message news:8A5A8EEE-CC4B-4DD5-9189-73E266C67DA7@microsoft.com... You'd be better off asking this in an Excel newsgroup.> 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. -- Mike Have done so and got no reply. Hence asking here.
Show quoteHide quote "MikeD" wrote: > > "Bobzter100" <Bobzter***@discussions.microsoft.com> wrote in message news:8A5A8EEE-CC4B-4DD5-9189-73E266C67DA7@microsoft.com... > > 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 > > >
Show quote
Hide quote
"Bobzter100" <Bobzter***@discussions.microsoft.com> wrote in message news:CAE1D335-F393-4D8C-9278-6BF5480973F7@microsoft.com... 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 >> "Bobzter100" <Bobzter***@discussions.microsoft.com> wrote in message news:8A5A8EEE-CC4B-4DD5-9189-73E266C67DA7@microsoft.com... >> > 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. 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 
Other interesting topics
PaintPicture
My concept for a very basic stripboard layouter in VB6 Put Date/Time on Right Side of Form.Caption With .... End With - Speed Public Thank You To Microsoft Days and Years - Data Comparing ActiveX Control Crashes - VB6 Does anybody know how to translate this C# code to VB6? config file Copy protection and license management programs |
|||||||||||||||||||||||
