Hi ,
I have an excel file where Column A contains a list of paths to various other Excel files.
E.g
c:\file1.xls
d:\file2.xls
c:\folder\file3.xls
I want a macro that opens each file in the list and picks the value in cell A1 of each excel file and populates another excel file with the values in A1.
Hello jb2009,
Welcome to the Forum!
This macro will examine the workbook the macro is in for the file list. The list is assumed to be "Sheet1" starting with cell "A1". Each workbook will be opened and the contents of cell "A1" on the first sheet in the workbook will be copied into a new workbook starting at cell "A1" on the first sheet. If have any problems, let me know.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks