Anybody know if you can combine two excel workbooks into one, automatically? I have two workbooks that are generated. I would like to have one workbook that would pull these two into it, but without any intervention by me. This is so easy by hand by just dragging and dropping the sheets into one workbook, but I would like to automate the process so that when the files are generated, I will be able to just have a third file that has both of these sheets as part of it. Maybe this needs to be done with VBA? Also, can VBA scripts be run from the command line?
|