microsoft excel courses london - Macros to link workbooks

The UK's most regular instructor-led training courses.
Training information: microsoft excel courses london · Excel course · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Macros to link workbooks

Jenny has attended:
Excel Advanced course
Excel Intermediate course

by - delegate Jenny [1 post] (2007 Feb 27 Tue, 11:34) Reply

Can a macro be used to pull in new monthly data from a number of workbooks into one master workbook?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Macros to link workbooks

by - trainer Amanda diamond contributer [1217 posts] (2007 Feb 27 Tue, 15:06) Reply

Hi Jenny

Thanks for your question.

This is something you could do using a macro but it would be a rather complicated one. This would be the sort of thing that the Excel VBA course would cover.

thanks
Amanda

· Do You Really Need Excel VBA Training?
· Excel and Inventory Management
· Why Should I Learn Visual Basic in Excel?
· Tools From Advanced Excel Courses: Goal Seek and Solver
· Prepare for your MOS Certification with MS Excel Courses