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