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

 

[fmm]

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

 

[BukHix]

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

Let me know if you have more questions.

 

[Rich_Lovina]

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