connections

I'm using auto refresh connections and want to put the time of the last connections refresh into a cell. Is that possible?

I use auto refresh connections, set to every minute. It seems to clear my clipboard so if I copy something and a refresh occurs I can't then paste. Is there a way around this?

Hi there, I have a code for creating a separate worksheet for any active sheet out of a master workbook that has data connections in it. now i am looking for a way to insert macro code that can: make sure this new workbook being created is matching the original format disconnecting all the...

I got a WSDL file to start to develop a way to communicate and extract data from a vendor web service. First time I face this kind of files. I loaded into Excel 2016, and I got a "DATABASE" with one record with these headings: "Attribute: name" and "Attribute: targetNamespace". I have no idea...

Trying to post excel and pdf to shared network with a generic user/pword. Getting Multiple connections error. Error is run time error "Multiple connections to a server or shared resource by the same user, using more than one user name, are not allowed. Disconnect all previous connections to...

Hi, I have multiple pivot tables and various slicers connected to them. I have since needed to create a new pivot table using the same source data. I then want to connect the existing slicers I am using to the new pit table. However, when I try this, the new pivot table does not appear in the...

Hi - Does anyone have a workaround for executing a VBA generated SQL command via ODBC on a Mac? This works in Windows, but fails on a Mac. stSQL1 is a string variable having the text of the SQL query. The code fails on the With statement: With...

Hi all I am trying to write some VBA code to delete all Power query connections & Sources from my workbook. So far I have the code below, this does delete the connections but when I open the 'Show Queries' list all of my queries are still there. FYI I dont want to delete the actual tables...

Hello All, I have a connection in my workbook to refresh exchange rates every 30 mins. I would like to know after the refresh if the rate is down or up from the previous rate using some form of advanced conditional formatting. Is there a way to do this using some sort of IF statement in VBA...

Hi there, I'm trying to modify some code on a file that has about 30 different modules without any descriptions. Is there a way I can track back to see which module has the code assigned to populate the cells I want the code modified for? Kind of like "find connections" in excel? Many thanks!!

I've created a workbook with a simple data extraction from a SQL server that loads to a Table. It works great on my computer, but when I try to distribute it to other people, the Table's connection to the SQL Server query is lost, so they are unable to update the data in the table. The...

Hi, I have an Access database where I upload data from several sources. I then use this file to create a PowerPivot database in Excel, to which I add several calculating columns, relationships and hiding some column lists from the "client tools". Once I have done this, the PowerPivot is ready...

I created a multi-sheet workbook with multiple tables and a pivot chart on the computer. When I try to open that workbook in excel on my tablet however, it keeps giving me an error saying that it can't open workbooks with text queries. I clicked on the "connections" button and deleted all of...

Hi, I imported data located in 2010 SharePoint site and used it with Power Query to create reports. Recently, my team switched to 2013 SharePoint site and they stopped adding items to the 2010 site. How can I change the connection to import the same table from 2010 SharePoint site to the 2013...

Excel 2010 I have created 2 connections to 2 excel spreadsheets on a shared drive that contain the data I need to reference. I created the links using connections button in the data tab and then I have created 2 tables in 2 seperate sheets using the get external data, exsiting connections...

Hi everyone, I have the following code which opens a connection to a text file and imports it into my chosen range within my workbook. Sub ImportTextFile() Application.ScreenUpdating = False Application.DisplayAlerts = False With Worksheets("Prov_Data").QueryTables.Add( _...

I wanted to make a VBA subroutine that created a connection to each excel file in a given folder, give each connection a specific name, and create a link to a named range in each connected file so that I can refresh all of the data from these files into one worksheet. The imported excel files...

Hello: My instructions for this workbook are as follows: 1. Hit refresh in the data tab under add-ins 2. Within formula, fix the zeros by adding Iferror(0,…) and then add one more bracket at the end. (All of the cells don't call values from other cells, so I am unsure how to reference the...

I am getting this error on a workbook connections refresh that is done in VBA. I am using Excel Professional Plus 2010 and Windows 7. The code is part of a complex workbook that has 20 sheets, 330 procedures and 8,326 lines of code. The module with the error modifies a connection to an Access...

I have an Excel workbook with eight data connections to various SQL Server data sources, most of them stored procedures that return tables of data. The connections are set to refresh either when the workbook is opened or automatically when the contents of the cells that contain the SP...