Excel get Linksource

Recommended Posts

Fraser 0

Fraser 0

I'm trying to get the link source of a load of excel file and then change them to a new link, however for some reason when I use _excelbookopen to open the book I can't then use the returned object to get the link source ($aLinks = $oExcel.LinkSources($xlExcelLinks))

Share this post

Link to post

Share on other sites

Fraser 0

Fraser 0

I am running an older version of autoit (3.3.0) this is the only version that I can get approved at work at the moment, I have submitted a case to allow me to install the latest version however this can take a while.

That makes scene, works in a similar manner as VB where you specify the object and then the workbook, thank you for your help.