Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
open work book
Hi, I would like to know,how to open a workbook (micr print.xls)automatically when i open a particular work book (micr.xls). any code? thanks nowfal -- nowfal ------------------------------------------------------------------------ nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003 View this thread: http://www.excelforum.com/showthread...hreadid=396241 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
open work book
Nowfal:
'it must be named Workbook_Open; it must be housed in the ThisWorkbook module Sub Workbook_Open() Workbooks.Open ("C:\xxx\xxx\MicrPrint.xls") End Sub Elizabeth "nowfal" wrote: Hi, I would like to know,how to open a workbook (micr print.xls)automatically when i open a particular work book (micr.xls). any code? thanks nowfal -- nowfal ------------------------------------------------------------------------ nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003 View this thread: http://www.excelforum.com/showthread...hreadid=396241 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
open work book
You can open the micrprint.xls in the Workbook open event of the micr.xls
workbook. You can access the Workbook open event from the "ThisWorkbook" module. For example: Private Sub Workbook_Open() Excel.Workbooks.Open("c:\micrprint.xls") 'Change to the correct path here End Sub -- David Lloyd MCSD .NET http://LemingtonConsulting.com This response is supplied "as is" without any representations or warranties. "nowfal" wrote in message ... Hi, I would like to know,how to open a workbook (micr print.xls)automatically when i open a particular work book (micr.xls). any code? thanks nowfal -- nowfal ------------------------------------------------------------------------ nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003 View this thread: http://www.excelforum.com/showthread...hreadid=396241 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
open work book
Hi, thanks, one more question, if i want to close another workbook ho it will be. nowfa -- nowfa ----------------------------------------------------------------------- nowfal's Profile: http://www.excelforum.com/member.php...fo&userid=1000 View this thread: http://www.excelforum.com/showthread.php?threadid=39624 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - open work book useage agreement | Excel Worksheet Functions | |||
work book open _ event | Excel Worksheet Functions | |||
App_change event to open all work book | Excel Discussion (Misc queries) | |||
I was messing arround with the VBA and now I get the macro warning when I open the work book but when... | New Users to Excel | |||
open work book to current date | Excel Programming |