Hi All
Hoping someone can help me out with this. I've managed to find a nice bit of code that allows me to open a closed workbook in order to write data into it from a opened workbook. But I keep getting an Object Required error when i try to run the code.
What I'm trying to do, is have the code go into the closed workbook, find the first empty row on the sheet, then write the data into it form the sheet 'mydata' which is in the opened workbook, (hope that makes sense?):
Feel like i'm almost there, just can't figure out the error!
any help would be greatly appreciated!
Many thanks in advance for your help
Bookmarks