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

[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 ?

 

[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

 

[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 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 -

Thanks Shane that did the trick