Thread: Copy a range of cells in an unopened workbook and paste it to the current workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Copy a range of cells in an unopened workbook and paste it to the current workbook
Hi

Why not open the workbook?
http://www.rondebruin.nl/copy3.htm

Or try this with a closed workbook
http://www.rondebruin.nl/ado.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"topstar " wrote in message ...
Help!

Can someone please help me with a macro to copy a range of cells from
one unopened workbook, and paste it into the current sheet of a new
opened workbook.

Thanks


---
Message posted from http://www.ExcelForum.com/



Reply With QuoteReply With Quote