Go Back   Access World Forums > Microsoft Access Discussion > Macros

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 02-03-2015, 12:31 PM   #1
jcbhydro
Newly Registered User
 
Join Date: Jul 2013
Posts: 187
Thanks: 82
Thanked 0 Times in 0 Posts
jcbhydro is on a distinguished road
Find & Replace Macro Script

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

jcbhydro is offline   Reply With Quote
Old 02-03-2015, 04:58 PM   #2
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 9,895
Thanks: 37
Thanked 3,213 Times in 3,114 Posts
CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice
Re: Find & Replace Macro Script

Quote:
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
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 02-03-2015, 06:03 PM   #3
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 31,279
Thanks: 9
Thanked 3,721 Times in 3,664 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Find & Replace Macro Script

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.

__________________
Paul
Microsoft Access MVP

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Old 02-04-2015, 02:30 AM   #4
jcbhydro
Newly Registered User
 
Join Date: Jul 2013
Posts: 187
Thanks: 82
Thanked 0 Times in 0 Posts
jcbhydro is on a distinguished road
Re: Find & Replace Macro Script

Thank you CJ & Paul,

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

Regards,

jcbhydro
jcbhydro is offline   Reply With Quote
Old 03-16-2018, 03:11 AM   #5
binmady
Newly Registered User
 
Join Date: Mar 2018
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
binmady is on a distinguished road
Re: Find & Replace Macro Script

good and tahnk
binmady is offline   Reply With Quote
Old 03-16-2018, 05:00 AM   #6
ridders
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 4,531
Thanks: 72
Thanked 1,113 Times in 1,037 Posts
ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough
Re: Find & Replace Macro Script

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
Attached Images
File Type: png SQLSearchReplace.PNG (57.0 KB, 68 views)
File Type: png SQLSearch.PNG (76.1 KB, 72 views)
File Type: png SQLSearch2.PNG (19.0 KB, 66 views)

__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left and leave a comment.

New example databases:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
ridders is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Find/Replace Macro DavetheVBNewb Macros 6 07-14-2009 02:31 PM
Find and Replace within a macro innocent_smoothie Macros 7 06-02-2009 12:58 AM
Find and Replace Macro Sorryaboutthemess Word 1 11-21-2007 07:22 AM
Find and Replace in a Macro susanmgarrett Macros 1 04-06-2006 12:35 PM
Find and Replace in a Macro susanmgarrett Macros 0 04-05-2006 01:10 PM




All times are GMT -8. The time now is 11:17 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World