Access Query Linked to Excel fixed rows

Bill Manville Wrote:
A better method of bringing data from Access into Excel would be to use
Data / Import External Data / New Database Query.

Alternatively you could clear the current table and repeat the process
you used previously to get the linked data.


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Thankyou for that. New database Query works fine and I can use the
Access written Queries as the input to MSquery. One question, can I
get the MSqueries to autorun on opening the spreadsheet in Excel
without being asked if I wish to do so?


--
Chris Edmunds

I think you would have to mark the queries as not running on startup
and then have a startup macro that runs them.

Sub Auto_Open()
Dim WS As Worksheet
Dim QT As QueryTable
For Each WS In ThisWorkbook.Worksheets
For Each QT In WS.QueryTables
QT.Refresh BackgroundQuery:=False
Next
Next
End Sub

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup