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: 10,208
Thanks: 39
Thanked 3,300 Times in 3,196 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 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,850
Thanks: 9
Thanked 3,827 Times in 3,770 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
Part time moderator
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,208
Thanks: 83
Thanked 1,532 Times in 1,427 Posts
ridders is just really nice ridders is just really nice ridders is just really nice ridders is just really nice ridders is just really nice
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, 102 views)
File Type: png SQLSearch.PNG (76.1 KB, 111 views)
File Type: png SQLSearch2.PNG (19.0 KB, 108 views)

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

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.
,
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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


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.

-----------------------------------------------------------------------------------
nil illegitimi carborundum est
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 10:48 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