I would like to write a macro that will open a designated excel file, (really
doesn't have to open it visibly, I just need to be able to insert items in
the next empy row) Order Form.xls, find the first empty row, insert values in
certain cells in that row based on values from the excel file that called the
macro, save the Order Form.xls file, close (if opened) and return to the
original excel worksheet. I have a function currently that does something
similar into an access file. Are the methods similar?