external connection

Hey all, i have a folder containing subfolder and each one has some excel sheets which all are connected to a single excel file. I have to move this folder to other computer, and I need a code or something to open each file and then: 1) change source to the linked file to the new location. 2)...

Hi, I have trouble with format of the data area from external data import. I do properly the connection to the external data and I proceed up to regular point (pasting the data into excel sheet), where I can choose to format the data as a table or pivot table or pivot chart. But I do not want...

I am using ETL Manager extract URL as an external connection (from Web) in Excel. However that always gives me a top row with cell A1 saying "DSS Report". I would like to get rid of that row so I tried to use the ETL URL as a data source for Power Query. When I go New Query -> From Other...

Dears, How can I search for a value in a TXT file and return its correspondence in an Array? In my Excel Spreadsheet, on cell A1, the user will type the airport code, like SBKP for example. It's always a 4 digit string. Then, the VBA code will check if there is the airport SBKP into my TXT...

Hey guys! Thank you for the immense help you have already given by being so active. I have an excel file with some VBA code (fairly new to the (for me) more advanced stuff). The code is working fine, and was working when I was creating it. Now when I make a change in the file, save, close...

I'm currently using Excel 2013, but will need this to work in earlier versions as well. I have a series of spreadsheets in Dropbox (for those who don't know, Dropbox keeps a cached folder c:\users\myuser\Dropbox). One spreadsheet is a 'master' spreadsheet that tracks some values on all of the...

While trying to connect Power Query to a list in SharePoint I continue to receive the following error: "We encountered an error while trying to connect to "[SharePoint Site]". Details: "SharePoint: Request failed (404): The remote server returned error: (404) Not Found. (Cannot find resource...

I am trying to write some VBA that will import some data into a query table using a .odc file that is stored in a sharepoint data connection library. I used the macro recorder to record the process where I add the connection, then go to the existing connections and import the data into a table...

Hi, i've an excel in which i am importing data from external .csv file using "Get External Data". This is working fine; but now that external .csv file is changed to .xls file. Now there is one way that i keep my external file as .csv file, which is not possible since i am using this file for...