| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
feed data in multiple files without opening them
Why can't you open the files?
Tim "M H" wrote in message ... 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 *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
feed data in multiple files without opening them
Hi Tim,
The list of files would be 150, and I remember that the feeding could be done without keeping opening and closing the files by stating the complete path of the files, but I just don't know the proper syntax to do it. Please help. *** Sent via Developersdex http://www.developersdex.com *** |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
feed data in multiple files without opening them
Try
http://www.rondebruin.nl/copy4.htm -- Regards Ron de Bruin http://www.rondebruin.nl "M H" wrote in message ... Hi Tim, The list of files would be 150, and I remember that the feeding could be done without keeping opening and closing the files by stating the complete path of the files, but I just don't know the proper syntax to do it. Please help. *** Sent via Developersdex http://www.developersdex.com *** |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening multiple XLS files | Excel Discussion (Misc queries) | |||
| Feed Data from Multiple worksheets to a Summary Worksheet | Excel Worksheet Functions | |||
| opening multiple files into one workbook, but multiple worksheets.... | Excel Discussion (Misc queries) | |||
| opening multiple .txt files from multiple folders | Excel Discussion (Misc queries) | |||
| How can I view files chronologically when opening multiple files | Excel Discussion (Misc queries) | |||
Hybrid Mode
