Replace text in Macro

[jcbhydro]

Good Evening,

I have two macros which produce multiple file outputs of database group data, one file for the data from each of about 30 groups. Currently the output is configured to produce files in pdf format.
I wish to modify this to produce files in rtf format. However, the traditional 'find & replace' feature does not appear available in the macro design facility. Is there an alternative method of achieving the required modification, other than by a manual step by step replacement of text.

Any suggestions would be gratefully received.

jcbhydro

 

[sneuberg]

I'd covert the macros to vba where this would be relatively easy. In the long run I think you'll find a lot of benefits in VBA over macros. If you need to learn about VBA I suggest this video series.

 

[jcbhydro]

Thank you for your prompt response,

However, I am really not very keen on going on the VBA route. I was looking for a simpler solution to the problem.

Regards,

jcbhydro