Change to file name argument of mulitple actions in macro.

  • Thread starter Thread starter sharon_hutchison
  • Start date Start date
S

sharon_hutchison

Apologies...I tacked this onto another post earlier by mistake.

I have a macro with 500+ actions, the
actions export the results of different queries into the same folder
but each as a separate spreadsheet. I now want to relocate where all
of these spreadsheets are located. I thought it would be as simple as
a find/replace but that doesn't seem to work.....I'm really keen to
avoid updating the Action Arguments of all 500+ actions
individually....is there a way to do this en masse without converting
the macro to VBA?

Thanks in advance.
 
Here is a link to a find and replace utility for Access that will work on all
objects, so you can do a find replace with it th change the parameters in
your macro. I don't know if the trial version will do it, but even if you
have to buy it is only $39 US. I consider it the best $39 I ever spent on
software

http://www.rickworld.com/download.html
 
Back
Top