I have an Excel .xlsm file which references external excel files (external app outputs to 2003 format). To consolidate the process across all of the individual output files, I have a VBA script based on
ActiveWorkbook.UpdateLink Name:="filename", Type:=xlExcelLinks
Though when I run the macro, save and exit. When I re-enter the file, Excel tells me the file is corrupt with unreadable content (pressing Ctrl, Shift + I returns the error code - 101648). It then runs off a laundry list of erroneous xml files, which is strange because i haven't a clue about XML.
However, when I manually update the references (enter the cell, press F2), save and exit - reentering the file, everything is fine? While i'm sure I can find an easy VBA alternative, i'd really like to get to the bottom of the issue, so I can navigate around in future projects.
ActiveWorkbook.UpdateLink Name:="filename", Type:=xlExcelLinks
Though when I run the macro, save and exit. When I re-enter the file, Excel tells me the file is corrupt with unreadable content (pressing Ctrl, Shift + I returns the error code - 101648). It then runs off a laundry list of erroneous xml files, which is strange because i haven't a clue about XML.
However, when I manually update the references (enter the cell, press F2), save and exit - reentering the file, everything is fine? While i'm sure I can find an easy VBA alternative, i'd really like to get to the bottom of the issue, so I can navigate around in future projects.