WallyBackman
10-18-2012, 05:56 AM
Hi All,
I have a Word 2003 document that contains about 300 links to numerous cells in Column 2 of an Excel worksheet. I now want to use the document as a template by changing the linked column to Column 3 and saving the document with a new name. I then want to repeat the process by changing the linked column from Column 3 to Column 4 and saving the document with a new name, over and over several more times.
I need help with the VBA code that will cycle through every link and change the Column number only. The Excel filename and row number remain the same. When I try to use the macro recorder, none of the steps of replacing the column number get captured.
Thanks for your time.
I have a Word 2003 document that contains about 300 links to numerous cells in Column 2 of an Excel worksheet. I now want to use the document as a template by changing the linked column to Column 3 and saving the document with a new name. I then want to repeat the process by changing the linked column from Column 3 to Column 4 and saving the document with a new name, over and over several more times.
I need help with the VBA code that will cycle through every link and change the Column number only. The Excel filename and row number remain the same. When I try to use the macro recorder, none of the steps of replacing the column number get captured.
Thanks for your time.