Refreshing Linked Excel File using VBA

  • Thread starter Thread starter Dkline
  • Start date Start date
D

Dkline

I am using Dev Ashish's code at
http://www.mvps.org/access/tables/tbl0009.htm

My problem is one of the linked files to be refreshed is an Excel file. The
three Access files update just fine. The Excel file returns an error #3343
"unrecognized database format 'C:\Fees Processing\Annuity Fee.xls".

I've been walking it through the debugger.

strTbl is set in fParseTable

strTbl = "Current Annuity FeeExcel 5.0;HDR=YES;IMEX=2;DATABASE = C:\Fees
Processing\Annuity Fees.xls"

Not sure why the first parameter above is "Current Annuity FeeExcel 5.0".
The name of the source data worksheet is "Current Annuity Fee" in that
workbook. I'm using Version 10 libraries so the 5.0 is a red herring or may
be gumming up the works.

How can I get this Excel file to be refreshed?
 
The code on that page only works when linking to Jet backends (i.e.: linking
to an MDB).
 
Back
Top