Re: $$Excel-Macros$$ Help with saving files with path in cell B2

Hi Ashish, First of all congrats! You are a big help to all of us :) Also, Thanks a lot for your help. you. I tweaked your code a bit and got it to work the way I needed. now I have another problem: I am combining files from different location into one sheet (a new workbook). The list of files

Re: $$Excel-Macros$$ Help with saving files with path in cell B2

try this http://akoul.blogspot.com/search/label/Merge%20data%20from%20multiple%20sheet%20from%20multiple%20workbook%20to%20a%20workbook On Sun, Jul 3, 2011 at 11:33 AM, Nasim nbeiz...@gmail.com wrote: Hi Ashish, First of all congrats! You are a big help to all of us :) Also, Thanks a

$$Excel-Macros$$ Help with saving files with path in cell B2

Hi, I am using excel 2010. I have searched internet and have come up with below codes to: 1- Open a folder 2- Loop through excel files and open them one by one. 3- Check existence of path in opened file (path is in the sheet called Path, cell B2 of opened file) 4- Give me a message if path does