View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ian Elliott Ian Elliott is offline
external usenet poster
 
Posts: 46
Default how tell if file already open?

Thanks for any help.
I have a macro that pastes some info into another workbook. I open the
workbook, then run the macro. I would like to make the macro code to open the
file if not already open. If I make the code open a file without checking if
it is already open, I would get a notice about opening it twice. So I would
like to code it so that it checks if the file is already open. How do I tell
if a file is already open? With workbooks.something? Or windows.something?
Thanks.