Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel VBA

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Excel VBA

Resolved · Medium Priority · Version 2007

Reply Tue 10 Aug 2010, 15:56Delegate Jack said...

Jack has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA Advanced course

Excel VBA

How do I take VBE modules from one Excel file and apply it to another Excel file without type all the coding again?

thanks

For upcoming training course dates see: Pricing & availability

Reply Thu 12 Aug 2010, 02:07Trainer Anthony said...

RE: Excel VBA

Hi Jack, thanks for your query. Remember that the code is just straight text so you can copy and paste it directly into new modules. However, the following should walk you through copying modules directly from one workbook to another.

http://office.microsoft.com/en-gb/excel-help/copy-a-macro-module-to-another-workbook-HP010014116.aspx

Hope this helps,

Anthony

Reply Thu 12 Aug 2010, 09:52Delegate Jack said...

RE: Excel VBA

Thanks Anthony for the reply. I followed the link you sent, when i click on view/project explorer, nothing happens.

I have the destination workbook opened, but it is not showing up in the VBE when I clock project explorer.

thanks
Jack

Reply Fri 13 Aug 2010, 21:15Trainer Anthony said...

RE: Excel VBA

Hi Jack. Are you trying to important the VBA into a 2007 .xlsx file (it won't let you, you need to import it into a macro-enabled file)? Also, is there any security attached to the VBA already in the destination spreadsheet.

It may be quicker to create a new module and simply copy and paste the code across....

Hope this helps,

Anthony

Excel articles

· MS Excel: Excel At Making The Most Of Your Christmas
· Creating Tables Automatically In Excel 2010
· Make Things Easier In Excel With Lists
· What's Better Than the Help Function in Excel? Microsoft Training
· How To Identify The Most Critical Data In A Large Excel Spreadsheet

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

Excel tip:

LARGE and SMALL functions and their uses

Two of Excel's most common functions are the MAX and MIN functions which will display the largest (MAX) or smallest (MIN) value in a series. What if you need the 2nd or 3rd largest or smallest values instead of the largest or smallest?

The =LARGE(array,n) returns the nth largest value of a series.

The =SMALL(array,n) function returns the nth smallest value of a series.

In both functions, 'n' represents the order of the number you want to display. For example, putting in 2 as n will give you the second highest number; putting in 3 as n will give you the third highest number.

View all Excel hints and tips