| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup workbooks in a folder from master book and save them
I want to open multiple workbooks one by one which are in a folder on my pc and then do vlookup based on the master file which is aready kept open by me.there are around 700 workbooks, so opening each one by one and doing Vlookup is a tedious task. Can anyone provide a solution macro for this wherein all the files get open automatically one by one and vlookup is done on them ??? after its done the file must be saved a nd closed automatically. -- luckyros ------------------------------------------------------------------------ luckyros's Profile: http://www.thecodecage.com/forumz/member.php?userid=337 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=98732 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update workbooks in folder, new name and save in new folder | Excel Programming | |||
| Duplicating Changes from Column A and B of Master Workbook to ColumnA and B of Other Workbooks - - Please help me, I can save days if my problem | Excel Programming | |||
| Duplicating Changes from Column A and B of Master Workbook to ColumnA and B of Other Workbooks - - Please help me, I can save days if my problem | Excel Programming | |||
| Open all workbooks inside a folder, run macro and save them? | Excel Programming | |||
| Using VBA in Excel to Make a Folder to Save Workbooks in | Excel Programming | |||
Threaded Mode
