Adding macro code to Personal Macro Workbook

M

mika

Greetings,

I have a .bas file and would like to insert this code
directly into my personal macro workbook. However, I
can't find a way to DIRECTLY insert the code. The only
thing close is to record a dummy macro, then step into
that macro and insert the *.bas code that I really want.
Can someone tell me of a better way to do this?
 
D

Dave Peterson

I'd just open the .bas in notepad and copy|paste to my favorite module.

but if you right click on the project (when you're in the VBE), there's an
"Import File" option that may work the way you want.
 
P

Paul Falla

Dear Mika
Open a new spreadsheet,Tools menu,Macro,Visual basic
editor. Now in the editor expand the VBAProject,Right-
mouse click on Modules, select imporrt file and then
browse to your .bas file.
Hope this helps you

Kind regards
Paul Falla
 
Top