Excel VBA

Resolved · Medium Priority · Version 2007

Tue 10 Aug 2010, 15:56 Delegate 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

Thu 12 Aug 2010, 02:07 Trainer 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

Thu 12 Aug 2010, 09:52 Delegate 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

Fri 13 Aug 2010, 21:15 Trainer 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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Hide data in Excel Worksheets

Let's say you have some data in cell 'C5' you would like to hide from the casual viewer.

Click cell 'C5' to select it.

Click the 'Format' menu, select 'Cells'. When the 'Format Cells' dialogue box opens, click the 'Numbers' tab (if necessary), then select 'Custom' from the 'Category' list.

Double-click the 'Type' entry box and type three semi-colons: ";;;"

Click 'OK' to close the dialogue box and accept the new formatting.

The data in cell 'C5' disappears. It's still there and will work in calculations, but it isn't visible.

If you need to check the data, just click the blank cell and the contents appear in the 'Formula bar'.

View all Excel hints and tips