Editing Module thru VBA
 

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

Editing Module thru VBA
 

http://www.cpearson.com/excel/vbe.htm

at Chip Pearson's site.

--
Regards,
Tom Ogilvy

"MacroAlan" wrote in message
...
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.
--
Alan

Editing Module thru VBA
 

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

Regards
Frank
-----Original Message-----
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.
--
Alan

.

Editing Module thru VBA
 

Why not just create an add-in for you VBA, lot simpler than adding code on
the fly.

--

HTH

RP

"MacroAlan" wrote in message
...
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.
--
Alan

Editing Module thru VBA
 

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" wrote:

Why not just create an add-in for you VBA, lot simpler than adding code on
the fly.

--

HTH

RP

"MacroAlan" wrote in message
...
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.
--
Alan