Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Switching between workbooks
Excel 97. Trying to follow an example posted to this BBS and I am
getting errors. I am trying to switch easily between workbooks for copy and paste operations. I need some help. Sub test() Dim wb1 As Workbook Dim wb2 As Workbook If Workbooks.Count = 2 Then Set wb1 = ActiveWorkbook Set wb2 = "c:\library.xls" End If Error message reads "Compile error type mismatch" for wb2 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |