Macro to open a workbook
 

just want a simple macro that I can assign to a autoshape to open a
workbook.


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=469194

Macro to open a workbook
 

Hi Oberon.

Turning on the macro recorder and opening the workbook manually will provide
you with code.

Alternatively, look ast VBA help for the Open method and see the
accompanying example.

---
Regards,
Norman



"oberon.black"
wrote in message
news:oberon.black.1vo0ef_1127232349.3635@excelforu m-nospam.com...

just want a simple macro that I can assign to a autoshape to open a
workbook.


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile:
http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=469194

Macro to open a workbook
 

simply code, just had to think about it.

Code
-------------------

Workbooks.Open "drive letter:\folder\file name and ext"

-------------------



Thanks for lookin

--
oberon.blac
-----------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...fo&userid=2673
View this thread: http://www.excelforum.com/showthread.php?threadid=46919