![]() |
|
![]() |
|
Thread Tools | Display Modes |
|
#1
|
||||
|
||||
![]()
Excel can't 'automatically' load files via formulae; you'd need a macro to automate the process. Such a macro could be made to work with the text you have in the columns, though you really don't need anything more than the text file's name (i.e. without the path & extension on every line) and you'd also need to put some code into the macro that would specify where on each sheet the data are to do.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
Tags |
different sheets, file path, import .txt file |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
tiwas | Excel | 1 | 10-07-2014 04:57 AM |
Combine Data From 2 Sheets into a new sheet | bremen22 | Excel | 1 | 09-11-2013 12:59 PM |
![]() |
emilypage | Word | 3 | 11-09-2012 01:11 AM |
Loading Image Files Into WORD Table | cbjroms | Word | 0 | 10-19-2011 10:10 AM |
![]() |
diegogeid | Excel | 2 | 09-30-2010 12:19 AM |