Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query Help
I have built a query and have the following code on a command button to
refresh the query. Private Sub CommandButton1_Click() Sheets("Invoice Due").Activate Range("A7").QueryTable.Refresh BackgroundQuery:=False MsgBox "Refresh complete" End Sub When I run this it goes through the motions and asks for the parameters set and then i get the Refresh complete however I am not getting any infromation returned. When I run the report independantly of this code/button I do get the information. Can anyone help me identify what is going wrong please. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query Help
Never mind! I solved it myself! There is a first time for everything!
"Leanne" wrote: I have built a query and have the following code on a command button to refresh the query. Private Sub CommandButton1_Click() Sheets("Invoice Due").Activate Range("A7").QueryTable.Refresh BackgroundQuery:=False MsgBox "Refresh complete" End Sub When I run this it goes through the motions and asks for the parameters set and then i get the Refresh complete however I am not getting any infromation returned. When I run the report independantly of this code/button I do get the information. Can anyone help me identify what is going wrong please. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |