Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query Table - weird results
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query Table - weird results
I got to know the reason behind this...but not very sure...
Earlier i was creating the excel object dynamically as my project was not having the reference of Excel library ... but as soon as i made the object of excel ( application , workbook , worksheet ) static it worked!!!! Any other suggestions??? "sandeep" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table refresh causes the sort to look weird, help please | Excel Discussion (Misc queries) | |||
Weird pivot table errors | Excel Discussion (Misc queries) | |||
COUNTIF provides weird results | Excel Worksheet Functions | |||
weird pivot table problem | Excel Discussion (Misc queries) | |||
Web Query Sleep for until results come | Excel Worksheet Functions |