|
|
#1
05-26-2012, 06:10 AM
|
|||
|
|||
vba change external data source
I have a workbook that I want a user to be able to easily change the source of the external data. the data is a table that was saved as an excel file. the external file will be saved each week as week 1, week 2, etc. I want the user to be able to run a macro that will prompt them which week they want to use as the external data and then have the macro change the source so the workbook will import the correct file.. thanks 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Link and change source for multiple tabs from excel to powerpoint | excel3 | PowerPoint | 1 | 01-19-2012 02:01 AM |
 Automatically Selecting a Data Source
|
Nathan_Newlin | Mail Merge | 1 | 12-06-2011 03:42 PM |
| Edit Data Source- Linking template charts to new data | lbf | PowerPoint | 0 | 10-28-2011 12:19 PM |
| pivot table source data | hannu | Excel | 0 | 07-03-2010 04:54 AM |
| Help w/ external data | bellest | Excel | 0 | 11-11-2005 12:51 PM |
Windows 7 64bit 
Office 2003
Threaded Mode