connection

  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. A

    Show Pivot Table data connection name

    Is there anyway to show the name of the data connection either in or outside the pivot table?
  3. N

    Message Box Pop up twice while closing workbook event

    Hi All, I am using below code to save the current file in another location and also want a pop up message if user want to save a copy of file or not ? but every time I am closing the workbook the message box pop up twice. Can anybody help me out what mistake I am doing ? Private Sub...
  4. M

    Can I make my VBA trigger automatically off a cell updated from a DDE link?

    Here's what I'm trying to do - use Excel's DDE capabilities to communicate with a Rockwell PLC. For a proof of concept, I'm setting a boolean tag in the PLC, which is read as 1 or 0 via the DDE link in Excel, and I would like that to populate a list of 10 random numbers between 1 and 4. I'm...
  5. J

    VBA to refresh power query then resume macro once the refresh is done

    Hi All, I've searched the internet and found a few threads on this topic. I've tried some of the concepts and have been having issues. I hope this is a simple fix that I'm just missing. I'm receiving a Run-time error '1004': Application-defined or object-defined error. But I feel like...
  6. B

    Keeping ADO connection open at all times

    Hi, I have an application built from an excel userform where users connect to an access database to pull and write data. However, now we have a decent amount of users using this program I want to keep track who is in the program. The best way I could think of was to create a second database...
  7. Z

    SSRS - Power query connection, refresh only PQ

    Hi guys, I managed to create connection from SSRS to power query, but our reports are slow and based on connection method I need to refresh PQ queries after Power Pivot connection, is there some macro/ option how to do it without clicking at every query manually? And ideally without refreshing...
  8. D

    Getting External Data From Access

    I created a split DB that is used throughout our small office. A couple of my coworkers need to move some of data to Excel from the tables in the back end that is housed on a shared volume inside of our LAN. First I setup the connections Using the basic "From Access" wizard, but that tool...
  9. B

    ADO Sql query across two databases

    I have a function I put together which allows you to connect to an ado database. I am having trouble figuring out how to adapt this to allow queries across multiple databases considering the connection string only includes Data Source parameter with one database directory to link to. If this is...
  10. A

    Check internet connection

    The link below shows various ways to detect internet connection. Sometimes you have a requirement to enter a user name and password to access the Internet, how do I check if I'm fully connected to the Internet...
  11. L

    ODBC Connection to Access in 365

    Hi, I have a file in which I created a new ODBC connection to a query in our Access DB in Office 365 by going to Data > Get Data > From Database > From Microsoft Access Database and searched for the query and added it. It works fine and refreshes for me; however, my peer is getting an error...
  12. B

    MS SQL connection that will work in Windows and Mac version of Excel Office 365.

    I have a spreadsheet that retrieves data from a SQL server. I can get it to work in Windows but when I try it on the Mac it fails and when I get it working on the Mac it fails in Windows. Is there a way to create a connection that will work in either version? Windows has to be trusted...
  13. M

    Connection to ThisWorkbooksDataModel missing

    From what I recall every workbook I opened had this connection whether it had a data model or not At any rate I cannot see it in ANY of my workbooks. The data models are there, but none of them have that anymore I used to use it to increase the number of rows I could drill down on. Any...
  14. S

    Link Multiple Slicers (into one)

    My slicers are using different tabs for sources, so they won't link in the report connection. I once created a massive slicer that would edit any slicers you attached to it without using the report connection feature. Although, for the life of me, I cannot remember how I did this. Any...
  15. K

    Use a cell value to query an external Access DB

    I use this forum all the time and it is awesome but couldn't find an answer this time. I got the below vba macro to work but want to use a cell value as the search value instead of typing it directly in the macro. I tried several different things but always returned an error I changed the...
  16. E

    Refresh all connections VBA

    Some of my workbooks have a connection that pulls data from a website. I need to batch open those workbooks and update the connection. The problem is that the code is not working, I suppose that's because I was unable to be "BackgroundQuery: = False" before reflashall and not wait until update...
  17. B

    ADO Events and Data Integrity

    Hi, I have built a userform in excel which stores all of its data in a access database. There are multiple users at once but only one connection to the database is allowed to ensure one table is not updated while another user is using it for something else. I am wondering if ADO and access can...
  18. Z

    Power Query connection to files on SharePoint - users cannot connect

    Hello, I am using Office 2016 and Windows10. I have 4 files all in a SP doc library - 1 main file with connections to 3 Excel files in the same library. I originally set up the connection using Data > New Query > From File > From (Excel) Workbook. Users had permission errors, I did some...
  19. M

    How to hide the queries and connection in Excel

    I created several PowerQuery but I want to hide it. Now, everyone clicking Data > Query and connection can find it. How to make it "invisible" to others ? Thanks
  20. A

    Join between tables

    Hello, Regarding the binding of tables in Power BI, I would like to know how to make this connection, in the habitiude in SQL, we do the join or the connection between the tables with a primary key, but in Power BI I noted that There are linked tables with other fields. For example in this...

Some videos you may like

This Week's Hot Topics

Top