connection

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

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

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

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

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

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

Wanting data source to refesh on opening Workbook however most of the options are greyed out. In particular "Refresh data when opening the file" Any advice appreciated.

I currently run the below, which deletes every Connection in my workbook. But I only want to delete those with names starting with the text "Connection". See the image below; at the bottom of that list of all of those names are a few that I created manually named "import_file", "finance", and a...

Hi guys, I hope you can help me with the SQL query below that I am running in Excel via the Data->Connection, error: Syntax error in FROM clause. Long story short, I used to do a data dump from our database into MS Access and then run the SQL code below from within Excel. It still works nicely...

Hi all, I have a Data Model with a couple million rows. I can't load this as a worksheet in Excel 2013, so i've converted this into a data model. I want to be able to easily filter through my data and return relevant results, ideally with the help of Slicers. How can I input my Data model...

Is there a way to automatically turn a table into a connection based upon the value of a cell? Let me explain. Let's say I have a table called "Employees", i would want to be able to type "employees" into cell A1, run this code, and it would recognize that based upon what I typed into cell A1...

Hi, I have the following code to open connection to another workbook - copy a range and paste it to thisworkbook. However, after paste and closing the connection, values/formulas from part of the range changed. How could I prevent that aside from paste as values as I want to retain the...

Hi, Currently, I write VBA script to connect Oracle Database by using ODBC. But I found connection problem until I do steps to success inquiry to get data as followings: 1. Open excel file > Tab "Developer" > Visual Basic > Run button to get data Found error message Run-time error...

What is the Teradata connection string when connecting in VBA code? I understand that the provider now includes the version number.

Newbie question: In a project with a number of subroutines and functions that query and update a database, is there an advantage (or disadvantage) to having just one global database connection that is opened upon initialization of the project and stays open until the project is closed?

Hi, Is there a way to refer to a table imported (connection only) in the datamodel of the workbook for a lookup or a dropdown for example. Something like CUBEMEMBER("ThisWorkbookDataModel";"[Table1].[Column1].[All]")<strike></strike> maybe?

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

Hello, I have to use some excel files as sources for a Power Pivot I can't connect to the excel files. The files are already tested on another computer and they work The error message is (more or less) the provider information are not included in the connection string. Please add them and...

Hello, I am having an issue with extra rows and columns in a worksheet (will be referenced to as A), specifically with a data connection into another workbook (B). Worksheet A does not have currently have data beyond row 100, but the rows and columns (in the scroller) extend to excel's limit...

I am on Office 365 running 64 bit Excel, version 16.0.9126.2336 on a Windows 10 machine I am trying to understand the behavior and related VBA properties for a pivot table when I select a regular range of data on a sheet, then go to Insert>PivotTable, and choose the "Add this data to the data...