Macros

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

Resolved · Low Priority · Version Standard

Macros

Christof has attended:
Excel Advanced course

by - delegate Christof [5 posts] (2008 Feb 29 Fri, 16:16) Reply

Is there a way to export Macros and send them for an import? How can I easily transfer them. I already established, that I can send them as TXT...

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	5	book now	£219	£235
2003	2008 Sep 17 Wed	Southwark	0	FULL
2003	2008 Sep 17 Wed	Bayswater	5	book now	£195	£205
2003	2008 Sep 19 Fri	Bloomsbury	6	book now	£214	£230
Full Schedule: See all 125 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Macros

by - trainer Pete platinum contributer [799 posts] (2008 Mar 3 Mon, 09:24) Reply

Hi Christof, Thank you for the post,
You would usually only export the macro as text.

In Excel press ALT + F11 to bring up the VB editor. In the project explorer window on the left you should see the module containing your macro code. Just right click the module and select "EXPORT." Export to a floppy or your network drive or even email the module to yourself.

Follow the same directions on the other computer except select the "IMPORT" options and point to your saved module.
I hope that helps, best regards Pete

· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Excel Macros for the Non-Programmer
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Microsoft Excel Training: Essential for Today's Employees

Please browse our web site to find out more about
excel courses and other Microsoft training courses.

Excel tip:

##### displaying in Excel

When you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake.

This is a common misconception - what this actually means is that the cell is not wide enough to fully display the content of the cell.

All you need to do to see what is actually in the cell is to widen the column that the cell is in.

View all Excel hints and tips