View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shawn Shawn is offline
external usenet poster
 
Posts: 271
Default If Then to check if a workbook is open

I have a workbook names "Space.xls" and when a certain macro is run it goes
and pulls date from a workbook named "Moon.txt". This all works fine.

However, I need a code that will look to see if "Moon.txt" is open and if it
is not to skip that part of the code.






--
Thanks
Shawn