I am new here but here is the gist of what I need help on.

I have 2 excel files. One will be the Master data holder. The second is the input file.

I want to write a macro that will run from the input excel file that will find the first empty row in the master available and then copy a set of lines from the "input" file into the "master" file.

The help I need is how to open and run using these 2 different files. I already can run the copy commands once I can link the two excel files. I am using the "ActiveSheet.Cells(NUM, 2).Value = Worksheets("IF").Cells(2, 4)" command to copy between sheets. I just need to know the next step of going to a new workbook.

Whatever help is available would be much appreciated.

Thanks,

Chad Podsednik

It depends on how you want this to work but if all you want to do is open the file then

Workbooks.Open Filename:=xlPath

where xlPath is the path of the file (inc file name & ext)

if you have more sepcific questions I'd be happy to help