Help please !
Trying to poke values into a Excel spreadsheet from Access table using OLE.
Everything works fine (for several months)- software rolled out. But suddenly it has stopped working part way through the access table. I get an Error #1004.
Anybody know what this error is? I can't find a description of the error in either Access, VB or Excel. I suspect it might be a 'permissions' problem with the spreadsheet - but I do not 'own' the Excel file and nobody will admit to changing it !
(The access code has not changed and it works with an old version of the spreadsheet!)
Any assistance would be appreciated.
Thanks in advance.
Trying to poke values into a Excel spreadsheet from Access table using OLE.
Everything works fine (for several months)- software rolled out. But suddenly it has stopped working part way through the access table. I get an Error #1004.
Anybody know what this error is? I can't find a description of the error in either Access, VB or Excel. I suspect it might be a 'permissions' problem with the spreadsheet - but I do not 'own' the Excel file and nobody will admit to changing it !
(The access code has not changed and it works with an old version of the spreadsheet!)
Any assistance would be appreciated.
Thanks in advance.