Hi again - today's problem:
At a given point in a script I am left with an excel document that is linked to data in another excel document; I would like to remove the links and leave only values and to do this from my Access module. I've tried using:
However, I understand that Access does not recognise Type:=xl... and I wondered if there was a numerical code I could use instead (had this problem with SaveAs until Chris suggested using -4143).
If not, could anyone tell me how would I "add a reference to Excel", Chris' other suggestion?
Many thanks...
At a given point in a script I am left with an excel document that is linked to data in another excel document; I would like to remove the links and leave only values and to do this from my Access module. I've tried using:
Code:
objXLApp.ActiveWorkbook.BreakLink _
Name:="V:\Information Services\Reporting Year 08 - 09\NCAs\Newham\Newham Live Workbook.xls", _
Type:=xlLinkTypeExcelLinks
However, I understand that Access does not recognise Type:=xl... and I wondered if there was a numerical code I could use instead (had this problem with SaveAs until Chris suggested using -4143).
If not, could anyone tell me how would I "add a reference to Excel", Chris' other suggestion?
Many thanks...