M
Mo
Hi,
I'm trying to open an Excel 2000 file from an MS Access 2000 database and
get 'Run-time error 1004' message telling me that the file cannot be found.
I've checked that the filename and path are both correct.
Anyone have any idea what I'm doing wrong?
TIA,
Mo
-----------code------------
Dim xlobj As Object
Dim strFileName As String
Set xlobj = CreateObject("Excel.Application")
xlobj.Application.Visible = True
strFileName = "T:\blah\blah"
I'm trying to open an Excel 2000 file from an MS Access 2000 database and
get 'Run-time error 1004' message telling me that the file cannot be found.
I've checked that the filename and path are both correct.
Anyone have any idea what I'm doing wrong?
TIA,
Mo
-----------code------------
Dim xlobj As Object
Dim strFileName As String
Set xlobj = CreateObject("Excel.Application")
xlobj.Application.Visible = True
strFileName = "T:\blah\blah"