Find path from linked xls book

[mrowe]

Hi,

Is there anyway to find the path of a linked spreadsheet to my access database.

The linked table name was changed and I can't remember what the real data source name is.

Thanks in advance
Matt

 

[smozgur]

Hi Matt,

Please open your database which you have linked table and goto VBA (Alt+F11). Goto Immediate (Debug) window (Ctrl + G) then copy and paste the following command line for the main source file name (Excel file path in this case)

print currentdb.TableDefs("tablename").Properties("Connect")

"tablename" is the current table name in Tables view.

to get the sheet or range name :

print currentdb.TableDefs("tablename").Properties("SourceTableName")

I hope it helps.
Suat

 

[Legacy 15162]

couldn't you just go to tools -> Database Utilities -> Linked Table Manager?