RunTime Error "1004" QueryTable is Invalid

  • Thread starter Thread starter Devendra
  • Start date Start date
D

Devendra

Hi,

I wrote a VB code automating Excel 2000. There is some
external data in my Excel sheet. While running this code
on my machine, its doing fine. BUT, while running on
another machine with Excel 97 its giving following error:

Runtime Error: 1004
QueryTable is Invalid.

All querytables are on Excel sheet itself I am just
opening the sheet through VB code and using the imported
data after refereshing the sheet through VB Code.

Thanks in advance,
Devendra
 
Back
Top