Steve,
Is the other workbook open. Although I have heard that you can move information into a workbook that is not open, I have yet to find anyone that knows how to do it. Therefore, I always make sure the workbooks I am needing to use are open.
I use the statement below to see if a spreadsheet has been opened.
The above statement uses the following function to see if a file is open and if it is not, it will open it.
See if that helps at all. To give credit where credit is due, I believe John Walkenback wrote this function.
Jeff
Bookmarks