Thread: syntax
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
libby ~xl97 libby ~xl97 is offline
external usenet poster
 
Posts: 1
Default syntax

Hi
Does anybody know what the syntax is for this:

I want an if statement that says

If Workbook(Results.xls) is open then
call a macro
else
do something else
end if

It's getting it to check whether the workbook Results.xls
is open and returning a true or false.

Thanks in advance
Libby