Recent content by kris2002

Hi Mala, I tried your code. I get an error when I compile the code using visual basic 6. Here is the error I get on the line "Dim SourceWkbk As Workbook, CombinedWkbk As Workbook". It gives me "User-defined type not specified". I have no clue how to fix it. If you could help me with this I would...

Mala, thanks for your input. I will definitely try this out and let you know. Thanks again.

I need some help with combining 4 different Exel Spreadsheets in to one Exel file with 4 sheets (one from each individual file). I want to do it using a Visual Basic script. My intend is to automate the process of combining 4 different Exel spreadsheets in to one Exel file with 4 sheets. Any...