change source location

  1. M

    Update External Link CODE

    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)...
    • mmagdy31
    • Thread
    • change source location external connection vba & code
    • Replies: 0
    • Forum: Excel Questions
  2. T

    Change folder location from desktop to drive - Power query.

    Hi, hope someone can help. I got a folder with excel-files on my desktop, that is linked to a power query. I like to change the data source (location) of this folder to my drive. (name & content are the same) - copy/paste from the desktop. I have tried to change "Data Source Setting" and...
  3. T

    VBA Pivot Table to Change and Look at Data Source based on Cell Value

    Hi, I really need some help in creating a macro whereby a Pivot Table's source is automatically changed and updated based on a cell value.... I have a Pivot Table which is in a Workbook Sheet Name of 'Stock VLookup' and in Cell D5 I have the Pivot Table. I want this Pivot Table to pull...
    • TTUK
    • Thread
    • cell value source change source location pivot table vba
    • Replies: 0
    • Forum: Excel Questions
  4. D

    Use VBA to Specify New Source Filename and Location

    I have a folder with around 40 spreadsheets, and each has a OLEDB Connection. I've written a macro that process each spreadsheet in the folder, and that works! :) I'm need to change the source filename, and location, using VBA. Assume the following: - Connection Name is "ThePrices" - new...

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
Back
Top