Hi all,
I have some simple code in an Access97 that just opens an Excel file on the server. This stops working on XP2 with office2003 (and an extra install of access97). It works fine on Windows2000 + office97 and on XP2 + office97.
Please do not suggest to upgrade/convert to access2003 : the application is written in access97 and just has to stay there.
I'm using some code like this :
Error on XP2+office2003+access97 = file not found
Tried this already on different PC's with the same error
Someone any idea's why this code won't open with excel2003 ?
Dave
I have some simple code in an Access97 that just opens an Excel file on the server. This stops working on XP2 with office2003 (and an extra install of access97). It works fine on Windows2000 + office97 and on XP2 + office97.
Please do not suggest to upgrade/convert to access2003 : the application is written in access97 and just has to stay there.
I'm using some code like this :
Code:
taskID = "excel.exe ""\\server\destination path\myfile.xls""
call shell (taskID,1)
Error on XP2+office2003+access97 = file not found
Tried this already on different PC's with the same error
Someone any idea's why this code won't open with excel2003 ?
Dave