help to understand 'querytable'

B

bobh

Hi All,

In Excel 2007 if I create a table using the process of

Data - Get External Data - From Other Sources - From Microsoft Query

and selecting MS Access Database and then finish the connection
process and create a table of data on a worksheet in a workbook

do I then have a querytable???

and if so could I then use things like
..QueryTable.refresh BackgroundQuery:=False

thanks
bobh.
 
I

iwer.moerck

Den onsdag den 21. november 2012 15.00.29 UTC+1 skrev bobh:
Hi All,



In Excel 2007 if I create a table using the process of



Data - Get External Data - From Other Sources - From Microsoft Query



and selecting MS Access Database and then finish the connection

process and create a table of data on a worksheet in a workbook



do I then have a querytable???



and if so could I then use things like

.QueryTable.refresh BackgroundQuery:=False



thanks

bobh.

I would say yes to that.

But the best way to find out is simply to try :)

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top