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