connections

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

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

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

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

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

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

I have several workbooks that I want to combine into one. I want to be able to easily pull information about each project based on the assigned ID. The workbooks have different columns, but all of them will have the ID. How would you combine the data? I was thinking using a power query, but...

I’m hoping someone can help with a problem dealing with data connections. I’m trying to create a tool that will refresh an existing web data connection on the active sheet, prompting the user to input a new URL. This is a generic utility, intended to work on any existing data connection. My plan...

Hi, I work with someone who installed the new excel 2016. For some reason when he clicks ‘data connections’ under the ‘data’ tab it shows up as a side panel instead of a box. We have found this to be difficult to use and limiting as there doesn’t seem to be a way to add new connections in a...

I have an Excel file that pulls data frommultiple text files via the "Connections" menu. The problem I'mrunning into is I need to be able to change the path to the text files fromwithin VBA.

I'm using Conditional Formatting to colour cells if they meet specific text criteria. I want to compare a value if it's either this or that, then if so, colour the row green. Easy to do, I would think. I can get the first part but not the rest because the value is already enclosed in...

Hi. I use linkedin in my work every day. I send different messages out. From linkedin you can export your connections and messeges. I have done this and can filter and make vlookup for the ones i have not send to. I would like to have a working macro, who can send to names in linkedin. To...

I have about 30 connections connected to different excel sheets within 1 workbook. I want to know how to get the command text for each connection using VBA code. This is what I have thus far: Function Connections() Dim conn As WorkbookConnection Dim celltxt As String For Each conn In...

He Guys, I am trying to read/import(actuel) weather data into an excel sheet. So i surfed the web for quite some time, but i am hoping you can help me out. I have some experience with vba, but not with reading data into excel. So i will explain what my idea is, I want to read/import actuel...

Hi all, I have a workbook (NXT Daily Update.xlsm) which has got a load of data in it. I have another workbook (CG Daily Update.xlsx) this workbook is made up purely of data connections. What i would like to do is have a vba macro which when runs closes NXT Daily Update, opens CG Daily update...

I used to use office 2016 and I could go to existing connections, select a file dsn and connect via ODBC to JDE iseries to run a query. Now on ProPlus, the file dsn no longer work, so I set up all the connections again and they are stored in "PowerBI style" with "Global Permissions" but I...

Hi All, I wonder if anyone can resolve this annoying issue I am having. I have created a Excel Connection Table and all my columns seem to work correctly however there is one column (Employee Number) that I am having issues with. When I look the column in the source it contains both numbers...

Good morning, I used to enter my SQL by going into Excel --> Data --> Connections and then add new connection. The tab now has a label called "Queries & Connections" and I can't see where I can add new connections, I've clicked on the new label, but there's nowhere I can see to add a new...

I am having an issue creating data connections in Excel 2016 (365 subscription) to a MS SQL View. When I attempt to create the connection it asks to load data. I've looked through the DATA >>GETDATA>>FROM DATABASE>>FROM SQL SERVER DATABASE in the advanced options area but couldn't find anything...

I would like to be able to control the display and hiding of the Query and Connections pane in Excel 2016 (Power Query). I have tried to find the object using the macro recorder but the open/close event doesn't get recorded. Can anyone tell me if this is controllable, and if so, how? Thanks Matt