Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
We have an engineer here who created a highly useful
workbook with VB Modules. He password protected the VBA Project. Unfortunately, he hard-coded a network path in these modules, and that path must change for reasons beyond our control. The problem is that this workbook has been copied literally thousands of times. All of them need to be fixed. They are all on mapped network drives that I can access, so I know where all the copies are. I've been looking for some way to automate a find / replace on all these workbooks, but I see there is no good way to use VBA to unprotect the modules. I'm not restricted to VB or VBA. I could do something in VC++ or Perl or whatever. Any suggestions on how to do the fix? Right now, he's facing the possibility of having to manually open and unprotect thousands of workbooks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Alter mulitple Vlookups at once | Excel Discussion (Misc queries) | |||
VBA password protected modules | Excel Discussion (Misc queries) | |||
Protected modules | Excel Discussion (Misc queries) | |||
Export modules from protected projects | Excel Programming | |||
Unlocking pwd protected vba modules | Excel Programming |