excel microsoft training

excel microsoft training - Excel Macros

Resolved · Low Priority · Version Standard

Excel Macros

Ben has attended:
Excel Advanced course

by - delegate Ben [1 post] (2007 Oct 10 Wed, 16:04) Reply

When recording a macro can I open up seperate folders & Documents that links back to current worksheet?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	3	book now	£475	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	4	book now	£499	£530
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	8	book now	£345	£425
2003	2009 Jan 22 Thu + 23 Fri	Southwark	5	book now	£450	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel Macros

by - trainer Pete platinum contributer [801 posts] (2007 Oct 11 Thu, 14:30) Reply

Hi Ben, Thanks for the post. Yes you can record a macro which will open different documents, the macro will record your mouse clicks and key strokes and replay them when you call it up, however it may be useful as an alternative to create a Workspace icon which includes all the linked workbooks and then record a macro to open the workspace icon, which will simplify it considerably.

· Creating Charts with Excel
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Microsoft Excel's Best Kept Secret

Excel tip:

Change the Value of a Constant

When using a named constant in a worksheet, you may wish to change the value of that constant.

From the 'Insert' menu, select 'Name', then select 'Define'.

In the 'Define Name' dialog box, select the constant that you want to change.
Change the value in the 'Refers To' box.
Click OK.

Wherever that named constant has been used it will now use its new value.

View all Excel hints and tips

Rate this page: