Case solved:
I've been overlooking .SourceTableName = "Sheet1$" or whatever you want it to be...
The following is the case:
At our office we have users which use English and Dutch systems and office software. They pull data out of another system and export it as an Excel-sheet which gets used by my database for further calculations.
My database uses a linked table to the Excel-sheet because it gets updated about 10 times a day, however depending on who exports the sheet the tab will be named "Blad1" or "Sheet1". The name of the sheet will always be the same so they can just overwrite it. (This proves to be more convenient for them.)
When an user on an English systems exports the sheet then my database will not recognize the Excel-sheet and it will not work.
I tried to use refreshlink but it always fails. I also tried dropping the link and make a new one, but I fail there too.
Can someone please help me to get this fixed or point me in the right direction. (I tried searching the forum but i have not found a solution.)
Any help is appreciated, m0use
I've been overlooking .SourceTableName = "Sheet1$" or whatever you want it to be...
The following is the case:
At our office we have users which use English and Dutch systems and office software. They pull data out of another system and export it as an Excel-sheet which gets used by my database for further calculations.
My database uses a linked table to the Excel-sheet because it gets updated about 10 times a day, however depending on who exports the sheet the tab will be named "Blad1" or "Sheet1". The name of the sheet will always be the same so they can just overwrite it. (This proves to be more convenient for them.)
When an user on an English systems exports the sheet then my database will not recognize the Excel-sheet and it will not work.
I tried to use refreshlink but it always fails. I also tried dropping the link and make a new one, but I fail there too.
Can someone please help me to get this fixed or point me in the right direction. (I tried searching the forum but i have not found a solution.)
Any help is appreciated, m0use
Last edited:
