Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-07-2015, 03:40 PM
Doug Needham Doug Needham is offline Excel data linked to external source Windows 7 64bit Excel data linked to external source Office 2013
Novice
Excel data linked to external source
 
Join Date: Nov 2014
Posts: 20
Doug Needham is on a distinguished road
Default Excel data linked to external source


I have an Excel file with a large number of records (rows). Each row will be linked to a separate external source file.

I'm trying to setup a macro that will quickly create and change the external path for each row of data. All of the rows in my Excel file are consistent with the only difference being their source file. And the external source files are all similar to one another. So the only thing that's changing is the path. Is there an easy solution to this problem?
Reply With Quote
  #2  
Old 09-15-2015, 05:14 AM
macropod's Avatar
macropod macropod is offline Excel data linked to external source Windows 7 64bit Excel data linked to external source Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,938
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If you changed your formulae to use the INDIRECT function, you could store the path in a single cell, then change just that cell as/when needed. No macros required. Other than that, a simple Find/Replace should suffice. Again, no macros required.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Fill MS-Word docs/forms with name address data from external source yajnaval Word 2 02-14-2015 10:48 PM
Excel data linked to external source data linked from excel sheet megatronixs Word VBA 1 08-19-2012 11:09 PM
Excel data linked to external source drop down list from external data source Excel 2007? Intruder Excel 1 08-03-2012 05:41 AM
Excel data linked to external source vba change external data source excelledsoftware Excel Programming 1 07-17-2012 04:22 AM
Excel data linked to external source Refresh of data from external source Jirik61 Excel Programming 3 07-13-2012 01:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft