View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.scripting.vbscript
D. Pirate Roberts D. Pirate Roberts is offline
external usenet poster
 
Posts: 8
Default How to close file from vbs?

I know there must be a simple way to do this but so far I haven't found it.
I have a vbs file that writes output to an Excel file. All I want to do is
have the script close the file if it is open when the script is run.
Something like:

If test.xls is open
Close test.xls

Is this possible?