I have a word document (final test report) that grabs graph data from a large excel spreadsheet. The spreadsheet contains the tabulated results of around 4000 tests and the data is presented graphically. I have a Word report that grabs this graphical data and drops it into Word's own excel graphs. However, I cannot use template files as I have, on occasions, more than one device I am testing. Hence, each device has its own results folder and hence unique link paths. There are at least a hundred graphs in my word doc and I, so far, have manually edited the links (Which is DUMB!). How could I automate this task with VBA?