refresh connection

Hi Folks, I'm using Microsoft 365, so a current version of excel. I'm having issues with the following code to refresh all the queries I have in my workbook: Sub Refresh_All_Data_Connections() Call TurnOffStuff Dim objConnection As Object Dim bBackground As Boolean For Each...

Every week a new report comes out that I save as a text file and refresh in my Excel workbook, this is in sheet 1. As each week comes out, I start a new row and I copy and paste certain data from that report on sheet 1 to sheet 2. I was thinking that there must be a way to link the cells that...

I am getting this error on a workbook connections refresh that is done in VBA. I am using Excel Professional Plus 2010 and Windows 7. The code is part of a complex workbook that has 20 sheets, 330 procedures and 8,326 lines of code. The module with the error modifies a connection to an Access...

Hello, Our organization has about fifty scorecards in Excel, with three data connections apiece. All of them refresh from the same password-protected database. Is there a way to write a script that will open and refresh all the workbooks at once, wihtout having to type the login and password...

I have 15 reports which need to be updated using Excel. Current manual procedure is open file --> Click on "Refresh All" (Doing so will refresh all pivot table with external connection -OLAP) --> Close the file. This needs to be done for each 15 files. Can someone please help me with code for...

Hi I have a table in Access linked to 3 separate Excel sheets. They contain user forms which update the records in the table with information input into the form. Within the userform code, I'd like to do 2 things: 1. Update the records in the datatable with the user form info 2. Refresh the...

Hi All, Request your help in defining a macro for a command button which helps me to Autofilter and Copy from a SourceData file (w/o opening) which is stored at a location in d-drive and while pasting into another sheet (master file will have the sheets which are already created for the...

Hi All, Request your help in defining a macro for a command button which helps me to Autofilter and Copy from a SourceData file (w/o opening) which is stored at a location in d-drive and while pasting into another sheet (master file will have the sheets which are already created for the...

I've searched everywhere for the answer to this for 48 hours now and I really need some help. We're using a pivot table with an OLAP cube connection and we're getting false-positive results because of a user error. We have 4 row labels to classify the data and we're experiencing problems with...

Hi i'm trying to refresh a connection in a workbook using vba, (using a refresh every ten minutes will take up too much resource), i want to avoid prompts coming on screen. So far this is what i have it breaks at: .Refresh BackgroundQuery:=False And comes up with: Sub Rifresh() pathfile...