connections

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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.
  7. 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...
  8. 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...
  9. 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...
  10. 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
  11. 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...
  12. D

    Vba- ado connection

    I want to learn ADO connections. I want to copy data between closed files. Where can I start to learn?
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. P

    Text Highlight Color

    Hi I hvee cdebelow and whee the text isfor forward plaaning I wantthis tohave a text highlight color of yellow please an you advise ow t do this? many thanks for your time "<br><br>" & "Forward Planning & JM-ing - ??." & "<br><br>" & "Many thanks, New Connections Team." Private Sub...

Some videos you may like

This Week's Hot Topics

Top