Update all Sheets

From: "Rich" <TrickDownie@xxxxxxxxx>
Date: 16 May 2006 08:02:18 -0700

I have 2 linked queries to My access database.
I have 4 Worksheets in my Excel file.

I created a new MAIN worksheet. I created a button that should update
my tabs with the 2 MS Access queries.

The below code is not working?

Set wks = ActiveSheet
For Each qryTab In wks.QueryTables
qryTab.Refresh
Next qryTab

.

Prev by Date: Re: In between the sheets?
Next by Date: Row Selection
Previous by thread: Re: In between the sheets?
Next by thread: Row Selection
Index(es):
- Date
- Thread

Relevant Pages

pivottable and OLAP cubes
... I have OLAP cubes on worksheets which draw data from an access database. ... Sometimes, some of these queries return no records, because there are none. ...
(microsoft.public.excel.worksheet.functions)
Re: Am I making things too complicated?
... > excel group or a MS access group, its a little bit of everything. ... > the worksheets are actually just SQL query which draw information from ... > the MS access database. ...
(microsoft.public.powerpoint)
How to set Optionbox value from code?
... I have an Excel applciaiton, it reads values from an Access database and ... One of these worksheets contains a group box with two option boxes labelled ... controls are NOT bound to any worksheet cells. ...
(microsoft.public.excel.programming)
Am I making things too complicated?
... excel group or a MS access group, its a little bit of everything. ... the worksheets are actually just SQL query which draw information from ... the MS access database. ...
(microsoft.public.powerpoint)