View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
DavidMc[_2_] DavidMc[_2_] is offline
external usenet poster
 
Posts: 1
Default Checking 2 c if workbook exists

Crashes out with Runtime error 52: bad filename or number.


-----Original Message-----
David,

Use Dir. For instance

If Len(Dir("C:\WINDOWS\WIN.INI")) 0 Then
MsgBox "Found"
End If


--

HTH

Bob Phillips

"DavidMc" wrote in message
...
I have two spreadsheets, one saved on a floppy disk

called
demo.xls and one stored on the c drive called

master.xls,
what i would like to do is to get master.xls to check
whether demo.xls exists on the floppy disk. how do i do
this?



.