Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
OK. Fixed it.Had to pu it aside and reread your post again. The
section on a file already open. Works great now. Thanks. Sub Create() Dim wb1 As Workbook Dim wb2 As Workbook Dim MapType As Variant Dim MapLineNo As Variant 'Dim HexNumberHigh As Variant Set wb1 = ActiveWorkbook On Error Resume Next Set wb2 = Workbooks("Library.xls") If wb2 Is Nothing Then Set wb2 = Workbooks.Open("C:\Library.xls") End If Is there a way to close workbook WB2 at the end of a macro? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Switching between Workbooks | Excel Discussion (Misc queries) | |||
Switching between workbooks | Excel Discussion (Misc queries) | |||
Switching Between 2 workbooks using VBA | Excel Programming | |||
switching between workbooks... | Excel Programming | |||
Switching Workbooks in vbscript | Excel Programming |