I found the answer to breaking out the job number by account manager.

M

M G Henry

I used Microsoft query to write specific queries and filtering the
data....

The problem I now have is how do I automatically update those queries
every time I open the job detail list... I can right click on the
cells and click update, but is there an automated way to update these
queries ?
 
F

FSt1

hi
not sure what you mean by "job detail list". is that a file????
use the workbook open event.
Private Sub Workbook_Open()
Sheets("Sheet1").Range("A1").QueryTable.Refresh _
BackgroundQuery:=False
End Sub

and then some people get off on selecting.... so....
Private Sub Workbook_Open()
sheets("sheet1").select
range("A1").select
Selection.QueryTable.Refresh BackgroundQuery:=False
End Sub

but techniqually selecting is not required.
adjust sheet names and ranges to suit.

Regards
FSt1
 
S

ShaneDevenshire

Hi,

What version of Excel are you using? When I right click a query I don't get
a command "Update", I do get a command Refresh data, is that what you are
refering to?

If you are connected in 2003 or earlier via Data, Import External Data, New
database query, then you can right-click anywhere in the query and choose
Data Range Properties, then choose Refresh every and set the number of
minutes you want the query to automatically refresh.
 
M

M G Henry

Hi,

What version of Excel are you using? When I right click a query I don't get
a command "Update", I do get a command Refresh data, is that what you are
refering to?

If you are connected in 2003 or earlier via Data, Import External Data, New
database query, then you can right-click anywhere in the query and choose
Data Range Properties, then choose Refresh every and set the number of
minutes you want the query to automatically refresh.

--
Thanks,
Shane Devenshire






- Show quoted text -
Click to expand...

Thanks Shane that did the trick
 
Top