Calling Another spreadsheet
 

I want to program a macro button to open another Workbook from within
my
presently opened Workbook.
The Workbook that I want to call is named 'Stock Plan Blank' and is
stored on my PC on D:\My Documents\Excel
I also want it to copy one spreadsheet named 'Stock Plan' from the
Workbook i'm working in to Sheet1 of the workbook I want to open.

How do I call it up and copy??

Easy for those that know how.


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=543348