>Does anyone have experience using an Excel object from a Visual Foxpro program using the QueryTables method? I am trying to populate 1 worksheet in a workbook containing 4 worksheet from a txt file.
>
>I appreciate any help!!
>
>Thanks!

with oExcel.ActiveWorkBook.ActiveSheet
 .QueryTables.Add('TEXT;'+sys(5)+curdir()+'mytext.txt',.Range('A1'))
endwith

  use myTable
  Copy to (lcFileName) type delimited with TAB
  With oExcel.ActiveWorkbook.ActiveSheet
      With .QueryTables.Add("TEXT;"+lcFileName, .Range("A1"))
        .Name = "Page "+ltrim(str(1))
        .BackgroundQuery = .T.
        .AdjustColumnWidth = .T.
        .TextFileParseType = xlDelimited
        .TextFileTextQualifier = xlTextQualifierDoubleQuote
        .TextFileTabDelimiter = .T.
        .Refresh(.F.)
      Endwith
  Endwith

Cetin