I regularly use Word documents (Word 2003) with approximately 300 links to cooresponding "referenced" Excel document. I am trying to create a macro that will allow me to change the chosen Excel reference file for the Word document. At this point I am able to get the macro to change all of the links if I manually enter the path to the Excel document in a textbox in the form of: "C:\\somedirectory\\somefolder\\somefile.xls". This becomes a problem when I try to use FileDialog(msoFileDialogFilePicker) because I can only get this command to return a path in the form of "C:\somedirectory\somefolder\somefile.xls". How would I go about getting the FileDialog command to returning the path in the form of the first string? Would it be better to convert the second string to the form of the first? How would I go about doing this?
Thanks.