VBA Conversion

Topic

New Reply

Okay, so i’ve spent MONTHS, off and on, creating the perfect VBA application in Excel. Now, I have to convert it for use in other departments. I’ve got all the aesthetics re-named to accomodate this, but is there a way to search ALL modules and lines of code for an instance and replace it with another?

I have a main userform, we’ll call it clientsupport. I have changed the name to techsupport. How can I do a MASS find/replace operation to go from clientsupport to techsupport?

Thanks in advance!

Reply | Quote

Replies

Drk:

Sorry, no good answer for VBA modules and objects in Excel, but thought I’d mention this for future reference. It’s an Access add-in authored by Rick Fisher that performs a fantastic Find and Replace through all objects in an Access db including modules. Best of luck!

Reply | Quote

In the 2000 editor, the Replace dialog lets you specify the entire project. Does that solve it?

Reply | Quote

Hi Drk,

If all your work is one single project, you can do a goto Edit | Replace and select current project as the object to work with. I have never used it but I assume it should work for you.

Andrew

Reply | Quote