Thread: Copy from one sheet in a workbook to another sheet in another work
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
mpeplow[_10_] mpeplow[_10_] is offline
external usenet poster
  
Posts: 1
Default Copy from one sheet in a workbook to another sheet in another work

Yes you need to have the workbooks open or tell the macro to do it for
you by using the following code

workbooks.open ("Filename")


--
mpeplow
------------------------------------------------------------------------
mpeplow's Profile: http://www.excelforum.com/member.php...o&userid=34812
View this thread: http://www.excelforum.com/showthread...hreadid=553856

Reply With QuoteReply With Quote