RunTime Error "1004" QueryTable is Invalid

[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

 

[BrianB]

Shared code should usually be produced in the oldest version it will b
used in