Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro in 2nd Open workbook | Excel Discussion (Misc queries) | |||
Open Workbook Macro??? | Excel Discussion (Misc queries) | |||
run macro on workbook open | Excel Discussion (Misc queries) | |||
how can I run a macro when I open a workbook? | Excel Discussion (Misc queries) | |||
Macro to open another workbook | Excel Programming |