backgroundquery=false

Hi All, I've used the macro recorder to record the loading of a power query to table and I'm curious if the last line of code is redundant? With Sheets("Temp").ListObjects.Add(SourceType:=0, Source:= _ "OLEDB;Provider=Microsoft.Mashup.OleDb.1;Data...

Hello all, I'm getting "Invalid Query" on .Refresh BackgroundQuery:=False when stepping through the code. Is there a way to import .xls files from the web using querytables? I've seen it done for .csv and I'm trying to adapt that code to xls. Thank you for helping! Sub XLSImport()...

Hi everyone I've created a button (with a VBA script behind it) to update all worksheets in my spreadsheet. The problems I'm having are as follows: 1. Even though I'm asking the script to take me back to the "DONUT VIEW" sheet it isn't. It does briefly but then seems to run through the entire...

Hello All, I'm new to this forum so I hope I am posting this in the right local. I'm at my wits' end with a macro designed to pull from Access. I'm receiving Run-Time Error '1004': Application defined or object-defined error The debugger selects ".Refresh BackgroundQuery:=False" at the...

Moved an excel spreadsheet which scrapes data off of a website from a PC with excel 2013 to new PC with excel 2016. Error occurs at " .Refresh BackgroundQuery:=False" (code snip below) I used the help in excel 2016 and it seems to referrence this as .Refresh ([BackgroundQuery]) but no...

I posted up a couple of months ago asking for help with a workbook: https://www.mrexcel.com/forum/excel-questions/1019628-workbook-has-repair-about-25-time-i-open.html I remade the workbook from scratch as suggested in the thread and deliberately didn't include the macro from the previous book...