querytable.refresh

I've tried so many variations on this code and still getting an error: "Object doesn't support this property or method." Sheets("Acknowledgements").ListObject("tblNotAckPrepped_2").QueryTable.Refresh BackgroundQuery:=False I just want to refresh a query table on a worksheet. The names of the...

I have set up a query from a pervasive sql database and would like to write some code that should execute before the query table is refreshed. I have put the following code in the sheet1 object where the table is located. This is just to see if I can get the before refresh event to work: Private...

I have the following VBA code which is failing with an "incomplete datasource" error on the last line: Application.ScreenUpdating = False Worksheets(Import).Select Range("F10").Select Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False The name of the ListObject is...

Hi all, I am trying to download a txt file using the following code. It is only downloading a few line of data and am not sure why. Any help is greatly appreciated. Thanks, O Sub Download() With Sheets(2).QueryTables.Add(Connection:="URL;http://www.asx.com.au/data/TheoPrices.txt"...

Hi, This is my 1st post on Mr Excel! - For years I just read and used solutions posted by others but I finally registered and hope I can also post something that somebody else can use. I have a list of MySQL databases (All sitting on remote machines) which I want to extract information from...