View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ph8[_37_] ph8[_37_] is offline
external usenet poster
 
Posts: 1
Default If workbook is open, save workbook?


Greetings folks!

How do you check to see if a workbook is open?

And furthermore, if you do find one that is open, is there a way t
force that open workbook to save? Maybe by initializing a loca
function or sub on the open workbook which just saves the sheet?

Also, what is the VBA code to open a workbook minimized?

Thanks in advanced for your time :)

--
ph
-----------------------------------------------------------------------
ph8's Profile: http://www.excelforum.com/member.php...fo&userid=1987
View this thread: http://www.excelforum.com/showthread.php?threadid=51815