Hi guys.

I have a number of Excel documents, each of which have an accompanying macro. Within this macro, there is an import statement.

Is there a way to automate the process of changing the location the import statement points to?

i.e. I have 20 excel documents that currently attempt to import from location x. I would like each document to import from location y.


Thanks!

Not sure if this would help you but I use the personal workbook for all my macros. Any macro you define in that workbook will be available in every other excel document you make. Would moving them into there possibly solve your problem?

Thanks for the reply.

Under "normal" circumstances I think the personal workbook would solve the problem; however, my task is somewhat atypical - I need to evaluate a series of Macros and note any errors. Because I need to preserve the idiosyncrasies of each macro, I don't think I can use the personal workbook.