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??

Perhaps convert the macros to VB and change the paths there.

This thread has a short "tutorial" for converting macros to VBA. The directions were written for Access 97 but with a little modification you can make them work with Access 2000/XP.

Topic: simple terms for visual basic (http://www.access-programmers.co.uk/ubb/Forum1/HTML/001293.html)

Let me know if you have more questions.

Thanks, from me too. This will help me with some of my postings too.