copying code from personal folder

  • Thread starter Thread starter Anders
  • Start date Start date
A

Anders

Hi All,

In xl03, my macro creates a new workbook, formats it and begins pasting data
from other sources. What I would like to do is at the beginning of the
macro, insert code from a module in my personal macro folder into the newly
created sheet's code (not add a module, but paste to the sheet's code). I've
tried recording it, but it only shows the open/close. I saw another post
from someone else on here that linked to a dead site. I could also store the
desired code in another workbook to access it, but still can't get to the
editing sheet code part.

TIA,
Anders
 
Hi All,

In xl03, my macro creates a new workbook, formats it and begins pasting data
from other sources.  What I would like to do is at the beginning of the
macro, insert code from a module in my personal macro folder into the newly
created sheet's code (not add a module, but paste to the sheet's code).  I've
tried recording it, but it only shows the open/close.  I saw another post
from someone else on here that linked to a dead site.  I could also store the
desired code in another workbook to access it, but still can't get to the
editing sheet code part.

TIA,
Anders
Click to expand...

Anders,

See Chip's site. Note though, that this will require you to trust
access to the VBA project object model, so be careful with what you
are doing.

http://www.cpearson.com/Excel/vbe.aspx

Best,

Matthew Herbert
 
Back
Top