Importing HTML files into Excel from MS Access

S

SleeplessTexas

I'm having a problem attempting to import files into an Excel workbook
programmatically from MS Access. I have DIM'd Applications.Workbook,
Worksheets as object etc. I've even gotten to the point of multi-selecting
the files through a commondialog procedure and reading the files into a
static table I've created, to include storing the path into a variable. The
procedure enumerates through the recordset and for each file it handles, the
import event line is:

With x1Sheet.QueryTables.Add(Connection:="FINDER;file:" & TestPath &
varFile, Destination:=Range("A1"))
.Name = varFile
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
etc.......

It seems to me there must be another way of doing this! Is there?
 
Top