Hi All,
I'm using Excel's querytable object to export data to excel thru a VB
program.
It works most of the time but sometimes i get some weird result while
exporting a recordset to excel.
On some systems though the Refresh Method of Querytable object retains
TRUE without any error, the data
doesn't reflect in the worksheet. I checked my recordset and all the
properties of QueryTable and found them
all right.
The interesting thing is that when i import the same data from Excel's
"Get External Data" Feature i get the
desired output.
Can anybody figure out whether it's problem with excel or something
else.

Thanks in Advance

Sandeep