Thread: Check for file before opening
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
simonhall[_7_] simonhall[_7_] is offline
external usenet poster
  
Posts: 1
Default Check for file before opening

Thanks Nick,

The line
If workbooks.open(filename) is nothing then creatfile()
is what I needed.

It seems funny to be writing code in words that I understand (ie "if __
is nothing then"). Just a matter of knowing what words work and what
order to put them in.

Works well now.

Simon


--
simonhall
------------------------------------------------------------------------
simonhall's Profile: http://www.excelforum.com/member.php...o&userid=30582
View this thread: http://www.excelforum.com/showthread...hreadid=561328

Reply With QuoteReply With Quote