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

  • Thread starter Thread starter M G Henry
  • Start date Start date
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 ?
 
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
 
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.
 
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
 
Back
Top