Find & Replace Macro Script (1 Viewer)

jcbhydro

Registered User.
Local time
Today, 08:30
Joined
Jul 26, 2013
Messages
187
Good Evening,

I have a couple of Macros which produce a lengthy sequence of pdf files from a Report.
I now want to pull these files from a Report with a different name. I wish to change multiple occurrences of the Report name using Find & Replace, but I haven't found such a facility. Surely it must be possible to do someething as simple as this.

Any assistance would be gratefully received.
Access 2010.

Regards,

jcbhydro
 

CJ_London

Super Moderator
Staff member
Local time
Today, 15:30
Joined
Feb 19, 2013
Messages
16,553
Surely it must be possible to do someething as simple as this.
Not with macros. One of the many reasons I don't use them:)

You can convert the macros to vba code and use find and replace there instead - but you won't be able to convert it back to a macro
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 08:30
Joined
Aug 30, 2003
Messages
36,118
There's a free tool called V-Tools that has a deep search that will do the find, but not sure if it will replace.
 

jcbhydro

Registered User.
Local time
Today, 08:30
Joined
Jul 26, 2013
Messages
187
Thank you CJ & Paul,

It seems that I shall have to do the necessary the tedious way - 26 times.

Regards,

jcbhydro
 

isladogs

MVP / VIP
Local time
Today, 15:30
Joined
Jan 14, 2017
Messages
18,186
V-Tools is free and very good
It can do Find & Replace for all database objects EXCEPT macros
The author is very helpful but AFAIK hasn't updated it for several years

Before i was aware of its existence, I built my own equivalent tool which can also do find & replace in all database objects INCLUDING macros







Currently not available as a standalone application though I could modify it given time to convert. However I would need to change for my time.

If interested, suggest you email me using the link below.
I can email a PDF explaining the tool - over 2MB (zipped) so too big to post here
 

Attachments

  • SQLSearchReplace.PNG
    SQLSearchReplace.PNG
    57 KB · Views: 358
  • SQLSearch.PNG
    SQLSearch.PNG
    76.1 KB · Views: 363
  • SQLSearch2.PNG
    SQLSearch2.PNG
    19 KB · Views: 341

Users who are viewing this thread

Top Bottom