Copy/paste without open target workbook.

[webdevptg]

Hi!,

I would like to know if it's possible to copy the information from an workbook that is open and paste another workbook, on a certain worksheet without opening the destination book.


PS: google translate

 

[ashakantasharma]

Pull data from a closed workbook

Extracting data from a closed file in another workbook is a common request by most of the excel user. They would like to pull or consolidate data from closed files; however, this is not possible. There is a workaround which … Continue reading →

www.exceltip.com