connection

  1. P

    How to enable data imports from other excel file through excel connections in Mac

    Hi Everyone, Hope you all are doing great. I want to keep importing 5 columns of data from Sheet A to sheet B, whenever I open sheet B. Though I can write simple macro for it, but I think there is an easier route as well through excel connections, importing data from an excel file is...
  2. B

    Access to access, is query the best option?

    All, What's the best way to bring data from one access file (user-oriented) to another one (main database center)? I tried using Append Query, but it adds all rows and not only the ones that are new. Moreover, it seems to be a manual process rather than an automated one. Thanks!
  3. A

    RefreshAll in Excel sheet which connects to SQL

    Hello guys, I Need to do Refresh All in Excel Sheet which connects to SQL. I tried Record Macro but i am not getting any code. Can anybody help on this please. In Excel Ribbon - Data Tab - Refresh All.
  4. 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...
  5. 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?
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top