Thanks!
But when i put the code in a module like this:
Sub testen()
Dim dbs As DAO.Database, tbl As TableDef
Dim stSource As String, stConnect As String
Set dbs = CurrentDb()
stSource = "Blad1"
stConnect = "Excel 8.0;HDR=YES;IMEX=2;ACCDB=YES;DATABASE=C:\Users\Lamyae\Desktop\Access...
I want to link my Acces database to Excel through VBA so that it will be done automatically..
So if something is edited it will be seen in excel directly without doing anything.
Can someone please help me :banghead:
I want to link my Acces database to Excel through VBA so that it will be done automatically..
So if something is edited it will be seen in excel directly without doing anything.
Can someone please help me :banghead: