module naming

[Eric]

I can open a module in Notepad and change the name of it there, but that
doesn't seem very slick. I want to create utility type modules (i.e., Excel
Utilities, etc.) that might be useful across different projects.

Isn't there an easy way to do this?

Thanks

 

[Word Heretic]

G'day "Eric" <[email protected]>,

Use a compiled language and write a DLL.

Steve Hudson - Word Heretic

steve from wordheretic.com (Email replies require payment)
Without prejudice


Eric reckoned:

 

[Jezebel]

Write it in one product (eg Excel) then export it.

 

[Jonathan West]

I can open a module in Notepad and change the name of it there, but that
doesn't seem very slick. I want to create utility type modules (i.e., Excel
Utilities, etc.) that might be useful across different projects.

Isn't there an easy way to do this?

Open the VBA editor. Select the module in the Project pane. You can then
edit the module name in the Properties pane.

 

[Eric]

Thanks for the reply Jonathan - the only properties dialog I have access to
however is the VBA Project one itself, which will let me change the project
name, but not the module name.

The other suggestion to export the module from someone else is useless too -
you can change the file name but when its imported back it still thinks its
'module1'.

 

[Jonathan West]

Thanks for the reply Jonathan - the only properties dialog I have access
to however is the VBA Project one itself, which will let me change the
project name, but not the module name.

The other suggestion to export the module from someone else is useless
too - you can change the file name but when its imported back it still
thinks its 'module1'.

Follow my directions carefully. I regularly rename modules within the VBA
editor. There is a properties pane for the module itself. It only has one
property - "(Name)", but it *is* editable. I do it all the time.

It might be that you have closed the Properties window for some reason,
accidentally or deliberately. Press F4 to bring it back if necessary.

 

[Eric]

Perfect, thanks!

Follow my directions carefully. I regularly rename modules within the VBA
editor. There is a properties pane for the module itself. It only has one
property - "(Name)", but it *is* editable. I do it all the time.

It might be that you have closed the Properties window for some reason,
accidentally or deliberately. Press F4 to bring it back if necessary.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup