connections

  1. M

    Load cumulative data from Web .csv data Query to Excel table for a different Parameter Date each time

    Hi all, I hope everyone is keeping well during these difficult times! I have an Excel Power Query question and I hope someone is able to help me! I created several connections in Power Query which are currently 'connections only' within Queries & Connections. All data is being imported from...
  2. S

    Remove old connections with VBA

    HI, I have seen multiple posts about removing old connections using VBA but they remove all connections. I have a sheet with 62000+ connections that have built up over time and would like to remove them and retain the 100 usable connections. Is there a way i can filter against the "Last...
  3. F

    Excel maintaining connections to Access

    I have multiple excel files with several connections to a single Access database. The problem I have is that if more than one file is open at once no one can refresh the files to draw in the latest information from Access. Unfortunately, as these are used for forecasting the files there will...
  4. B

    Updating several web connections with queries in blocks with dependent data

    I'm trying to update several connections in 2 blocks, the connection of the second block required data from the first block as input. To update the connections the user had to click on a button which starts the web data update process. During the update process a message is displayed (with a...
  5. E

    Excel 2016 error

    Hello all, I have issue where one of our Excel spreadsheets suddenly shows following error message. External Data Refresh Failed This Command requires at least two rows of source data. You cannot use the command on selection in only one row. We were unable to refresh one or more data...
  6. nikio8

    Delete server connections from excel

    Hi all, recently there seems to be a problem in excel where it constantly crashes. I am trying to make it as simple as possible with as few features as possible. The spreadsheet has few "workbook connections" to a local server. When I open data / connections/ they are there, but there does not...
  7. M

    excel crashes upon refresh of an exteranl data source

    Hello, I have been using 5 workbooks for about 3 years they al pull data from a master file. Now when I t to refresh connections it immediately crashes. The message says "Microsoft excel has stopped working" Any help would be appreciated.
  8. E

    Batch edit connections VBA

    Hi there. I want to edit the connections of the activeworkbook doing something like: Dim oCon For Each oCon In ActiveWorkbook.Connections oCon.Refresh BackgroundQuery:=False Next oCon The code above does not works. How can I do that? Thanks! EDIT: Better explain: I want to disable the...
  9. G

    Existing Connections

    Hello, I am doing a little house keeping to tidy andhopefully speed up so spreadsheets, I clicked on Existing Connections and gothundreds of reportserver connections listed. if I click on any of them its says noconnection. As the spreadsheet doespull information from a report server, is this...
  10. M

    Connections using Tables Not Updating Properly

    I have a master file that has data for a bunch of employees. I built seperately a file for each individual employee that reads from the master file, but found out that it can't read properly if they didn't open the master file, so started using Connections to pull in the data on a hidden tab to...
  11. D

    How to stop Excel from opening several workbooks connected to it

    Hello! I have a workbook with connections to 4 seaparate workbooks. All of a sudden when I open the main workbook, it opens all of the files connected to it. This did not happen before. How could I stop Excel from doing this, while refreshing the connections as it used to? Cheers
  12. H

    VBA to Refresh Connections

    Hi, I have code that automatically does a RefreshAll when a worksheet is activated. My issue though is that I need the refreshes to happen in a certain order since pivotables are based off of connection refreshes. I would need all connections to be refreshed first and then all pivotables to be...
  13. D

    Vba- ado connection

    I want to learn ADO connections. I want to copy data between closed files. Where can I start to learn?
  14. S

    Refreshing Website Connections - Including Date Of Refresh

    Hi everyone, I am currently using the Connections tools (under Data tab) to retrieve information from a website. In the end I will probably need about 50 separate Connections to retrieve all of the data that I would like. The problem i am facing is that when the data is refreshed, it does not...
  15. F

    Excel Formula Connection

    I pull several reports once a week and created a file with a ton of formulas to pull data from the reports. The reports must be open in order to extract the data. The report names are always the same as I use a macro to open the reports and then close them once the values have been...
  16. E

    VBA refresh query's

    Hey all, I have a bunch of excel workbooks that import via power query other exel workbooks and present it as clean data. Now i need to open all these books and refresh the query as i keep dropping new data into it. What i have now does not seem to do the trick.... I also tried RefreshAll...
  17. N

    VBA check Internet connections

    Hello, I'm looking for a VBA code that returns if there is an internet connections. There is a lots of code out there but the problom is that I didnt found a code that actualy works no matter what type of Excel version the user have (I mean 32 BIT or 64 BIT). I will be happy for help on this...
  18. B

    Excel 2013 won't format as a table after importing from a CSV using VB script

    I have a sheet that I am importing data from a CSV file that I then unlink it from the data and format it as a table. This works perfectly when I do it manually but when I attempt to do this with a Macro I always get a "Run-time Error 1001" unless I save and reopen the file. I delete the...
  19. M

    Connections vs RefreshAll

    I'm fishing for some guidance. I've recently started a position in a new company that uses Excel for reporting extensively. Most rely upon MSSQL to extract data via ODBC connections from SQL Server and Oracle into Pivots. The current level of automation tends to use (various) scripting options...
  20. baitmaster

    getting Connection information using VBA

    I'm analysing a bulk set of files and want to log details of each one, including any Query and Connection information. I'm struggling to extract the Connection String Within my code loops I have the following so far Debug.Print "_______________________" & vbLf & "Queries and Connections:" For...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top