View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Verify if a workbook exist with a macro

Hi Homero

You can use Dir

Sub test()
If Dir("C:\Data\test.xls") < "" Then
MsgBox "Exist"
Else
MsgBox "Not exist"
End If
End Sub




--
Regards Ron de Bruin
http://www.rondebruin.nl


"Homero" wrote in message ...
hello,
i want to verify if a workbook exist in a disk with a macro???

regardes