I need help in copying cells from a closed workbook (up to the last cell that has data) without using ADO, into an open workbook. Thank you.
I need help in copying cells from a closed workbook (up to the last cell that has data) without using ADO, into an open workbook. Thank you.
Your code needs to
switch off screenupdating
open the source workbook
copy the data & paste
close the source workbook
restore screen updating
Lots of examples on the Forum from myself & others
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks