LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
M H M H is offline
external usenet poster
 
Posts: 28
Default feed data in multiple files without opening them

An Excel file containing two columns of information, first column is a
list of .xls filenames (the list is created in DOS: dir -b *.xls
filelist.txt) and the second column is a list of corresponding strings

that need to be fitted into the F2 cell of the corresponding .xls file.
I would like to seek for help for accomplish it using VBA, and without
opening the list of .xls files.

*** Sent via Developersdex http://www.developersdex.com ***
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening multiple XLS files Mike Excel Discussion (Misc queries) 6 June 19th 08 08:20 PM
Feed Data from Multiple worksheets to a Summary Worksheet BT1113 Excel Worksheet Functions 2 April 7th 07 12:26 AM
opening multiple files into one workbook, but multiple worksheets.... Andy Excel Discussion (Misc queries) 0 January 24th 07 06:34 PM
opening multiple .txt files from multiple folders Corben Excel Discussion (Misc queries) 3 March 16th 06 12:43 AM
How can I view files chronologically when opening multiple files Stevilsize Excel Discussion (Misc queries) 3 July 26th 05 12:49 AM


All times are GMT +1. The time now is 06:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"