Editing Module thru VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a file that is created from a TXT file and formatted thru VBA. Using a
template is not an option.

I read that I could insert a module and add code to it from VBA. I plan to
add a series of User-defined Functions in the new module.

Documentation seems to be scarce.
 
hi,
not sure exactly what you want but alt+F11 with bring up
the vb editor. functions can be added there.

Regards
Frank
 
Why not just create an add-in for you VBA, lot simpler than adding code on
the fly.
 
I have a monster add-in that turns a TXt file into a huge XLS with lots of
calculations and summaries. I need to add a module to the resulting file so
that the new functions can run stand-alone.

It looks like Tom's reference to the Pearson web has what I need.

Thanks everyone!

Bob Phillips said:
Why not just create an add-in for you VBA, lot simpler than adding code on
the fly.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 - VBA to get a list of Module names in the project 4
Excel Add-In to catch application events 1
Option Private Module (for Object Modules) 5
How to change add-in object from within worksheet module. 3
how to keep the oiginal format of charts intact in excel vba afterdeleting a series ?? 1
Macro that will insert a simple text string in top cell of text file 1
How to call module function or sub from the Add In? 3
VBA Macro to open excel file and replace VBA module with update 3

Back
Top