Adding macro code to Personal Macro Workbook

  • Thread starter Thread starter mika
  • Start date Start date
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?
 
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.
 
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
 
Back
Top