Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do I open another file and set it as the active window??
|
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This will open another workbook from the same folder and run a procedure
that resides in it. As soon as it opens, it is the active workbook. Sub RunTracking() Dim cdir As String Dim wb As Workbook For Each wb In Workbooks If wb.name = "NCP Tracking.xls" Then MsgBox ("NCP Tracking.xls is already open.") Exit Sub End If Next wb cdir = ActiveWorkbook.Path Workbooks.Open cdir & "\NCP Tracking.xls", password:="NCP" Application.Run ("'NCP Tracking.xls'!RunUpdate") End Sub Mike F "Rossy" wrote in message ... How do I open another file and set it as the active window?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Excel Discussion (Misc queries) | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
Open a file do a macro ( made) and open next succesive file | Excel Programming | |||
Open File or Switch Between Windows if File is Open | Excel Programming | |||
Open File or Switch Between Windows if File is Open | Excel Programming |