HELP: Is it possible to use VBA to update links in multiple workbooks?

C

Clinton M James

Hi All,

I am re-orgnaizing folders in the office I work, problem is another team is
using our team's folder to store their stuff.

I am about to evict them into their own folder, however doing so will cause
issues which are critical to the business.

I am looking to have code go through every excel workbook it finds in their
subfolders and change the links to point to the new folder I will be moving
the data to. Is this possible?

is it also possible to make it detect any VBA code in any workbooks and
update the code to the new folder as well?

Any help is appreciated and I extend a thank you in advance.

Cheers,
Clint
 
N

Nigel

It is possible but not trivial. Chances are you would not capture all links
and references, which would compound the issue. Also if the VBA code is
protected you are going to have trouble reading and changing it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

External cell reference between two excel worksheets both in One Drive 0
VBA code for pasting links -- modifying RDB code for summary workbook 11
copying to new workbook 0
VBA loop to create named .csv files for all worksheets and workbooks in a folder 11
Need Help! Need to Change Linked Source on Several Workbooks. 0
embedding pw's to master sheet & auto update w/out pw's 0
Excel 2003 with VBA - "Can't find project or library" 6
VBA to copy from one workbook into another 0

Top