| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Workbook not Open Then Open It
Ok, this is what I did and it works great:
cwb = "Workbook 1" jbl = ThisWorkbook.Name On Error Resume Next Set wb = Workbooks(cwb) On Error GoTo 0 If wb is Nothing Then Set wb = Workbooks.Open(cwb) End If Application.Workbooks(jbl).Activate Thanks! -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
| Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
| excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
| Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) | |||
| Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) | |||
![scain2004[_10_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
