View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Raman325 Raman325 is offline
external usenet poster
 
Posts: 1
Default Accessing multiple workbooks through a macro


Hi guys,

Just so that you know in advance, I am a beginner at writing macros. I
fact, this is the first macro I've tried to write. Basically I have tw
workbooks and I would like to access both of them through a macro tha
I plan on running on one of the workbooks. I'm not even sure where t
look, and I know the first workbook can be accessed throug
ThisWorkbook, but I'm not sure how to get to the other one. Can anyon
help? Thanks in advance.

PS - Both workbooks are open in Excel and if possible I would like t
be able to access a cell selection I have made in the second workbook
but it is not imperative.

Rama

--
Raman32
-----------------------------------------------------------------------
Raman325's Profile: http://www.excelforum.com/member.php...fo&userid=2474
View this thread: http://www.excelforum.com/showthread.php?threadid=38315