how do I change 60 export destinations within a macro??

[donnycarr]

I have about 60 queries within 2 macros. I now need to change the export from one shared drive on our network to another. Is there a quick way of doing this rather than going into every TransferSpreadsheet 'Action' and changing the destination file name for every one.

It would be great it the Edit, Find & Replace function worked with a Macro, Design View.

Any Ideas??

 

[MichaelRed]

Conert the macro to Code. Use find and replace.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over