About QueryTable in Excel VBA - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

About QueryTable in Excel VBA

About QueryTable in Excel VBA# Database - 数据库

l*u2010-02-16 08:02

1 楼

Question about querytable in VBA.
As far as I know, it is linked to an external data source.
In my case, one statement is used: Selection.QueryTable.Refresh
BackgroundQuery:=False
My question is how do I check what kind of data source is linked? or the
content of the querytable?
Thanks

c*t2010-02-16 08:02

2 楼

check your dsn config

【在 l****u 的大作中提到】

: Question about querytable in VBA.
: As far as I know, it is linked to an external data source.
: In my case, one statement is used: Selection.QueryTable.Refresh
: BackgroundQuery:=False
: My question is how do I check what kind of data source is linked? or the
: content of the querytable?
: Thanks