Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Does the object already have a value set?
Hi,
I have an workbook object named "RespWkbook" I would like to check whether I have already assigned a workbook to it. If so then I would like to close the assign that workbook (because it has become old for me) and set a new workbook to RespWkBook. I tried if Not(IsNull(RespWkbook)) then RespWkbook.close set RspWbook = "//hari/desktop/NewWrkBook.xls" But it didnt work I also tried if Not(Isempty(RespWkbook)) then RespWkbook.close set Respwkbook = "//hari/desktop/NewworkBook.xls" again it is not working. Whats the right syntax for checking whether an object has value Nothing or not and be able to do the operation I want to do? Rgards, Hari India |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Does the object already have a value set?
Try
If RespWkbook Is Nothing Then ' no workbook assigned Else ' workbook assigned End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Hari" wrote in message oups.com... Hi, I have an workbook object named "RespWkbook" I would like to check whether I have already assigned a workbook to it. If so then I would like to close the assign that workbook (because it has become old for me) and set a new workbook to RespWkBook. I tried if Not(IsNull(RespWkbook)) then RespWkbook.close set RspWbook = "//hari/desktop/NewWrkBook.xls" But it didnt work I also tried if Not(Isempty(RespWkbook)) then RespWkbook.close set Respwkbook = "//hari/desktop/NewworkBook.xls" again it is not working. Whats the right syntax for checking whether an object has value Nothing or not and be able to do the operation I want to do? Rgards, Hari India |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Does the object already have a value set?
Chip,
Thanx a lot. It works nicely. Regards, Hari India |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Label Options - Forms Object vs Control Box Object | Excel Discussion (Misc queries) | |||
Option button object proeprties or object not found in vba | Excel Programming | |||
Confusion about how the Window object fits into the Excel object model | Excel Programming | |||
returning pivottable object from a range object | Excel Programming | |||
Range object to Array object conversion | Excel Programming |