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
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
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
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
