Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default How to test for Not Nothing

if I have a workbook object such as

dim wb as workbook

I know how to test if wb is nothing

but dumb question how do you test for Not nothing ???

if wb is not nothing then
wb.save
wb.close
end if
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,090
Default How to test for Not Nothing

If Not wb is Nothing then
HTH Otto
"jotor14" wrote in message
...
if I have a workbook object such as

dim wb as workbook

I know how to test if wb is nothing

but dumb question how do you test for Not nothing ???

if wb is not nothing then
wb.save
wb.close
end if



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default How to test for Not Nothing

Thanks sooo much.

"Otto Moehrbach" wrote:

If Not wb is Nothing then
HTH Otto
"jotor14" wrote in message
...
if I have a workbook object such as

dim wb as workbook

I know how to test if wb is nothing

but dumb question how do you test for Not nothing ???

if wb is not nothing then
wb.save
wb.close
end if




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you help test our Excel test? Jeff[_14_] Excel Discussion (Misc queries) 1 December 7th 09 05:11 PM
Calculate mean of test scores from rows of test answers RiotLoadTime Excel Discussion (Misc queries) 1 July 26th 06 05:14 PM
test..where are my messages..test HT New Users to Excel 0 January 23rd 05 06:23 PM
Test Todd Huttenstine[_3_] Excel Programming 2 April 27th 04 03:06 PM
test Billy[_2_] Excel Programming 0 November 26th 03 06:05 AM


All times are GMT +1. The time now is 06:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"