Problems liking to Excel worksheet using Excel 97 driver 
Author Message
 Problems liking to Excel worksheet using Excel 97 driver

I'm having a hell of a time linking to Excel 97 worksheet using Excel
driver. I'm getting an error message informing me that object 'Sheet1'
cannot be found.
However, I am able to link to a worksheet created by exporting a table to
Excel.
Below is the code i'm using:
Any help would be greatly appreciated.
Best regards
Swav Rybak

Sub LinkTable()

Dim db As Database
Dim tdf As TableDef
Dim rst As Recordset

Set db = CurrentDb
Set tdf = db.CreateTableDef("MonthTest")

tdf.Connect = "Excel 8.0;DATABASE=E:\tblMonth.xls;"
tdf.SourceTableName = "Sheet1"
db.TableDefs.Append tdf

RefreshDatabaseWindow

Set rst = Nothing
Set tdf = Nothing
db.Close
Set db = Nothing
End Sub



Fri, 05 Jan 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Converting Excel 97 worksheets to Excel 95 (don't have 97)

2. Problem using Excel 5.0 queries in Excel 97

3. Compatibility Problem Using MS Excel 97 VBA on Excel 2000/XP - Causes crashes

4. Problem pasting selected worksheet from Excel 97 into Word 97 as an object with no link

5. Protecting worksheets by using Excel 97 VBA

6. One worksheet used by Excel 5 and 97

7. Excel 2000 reading an Excel 97 Worksheet

8. Excel 97 worksheet crashes Excel 2000

9. Please Help - Excel 97 worksheet crashes Excel 2000

10. Can Excel 97 save as Excel 5 worksheet?


 
Powered by phpBB® Forum Software © phpBB Group