Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I would really appreciate if someone could help me with the below code. I want to see is a file labelled ??????w ia on the floopy and if it is run openme. If the file is not there or no disk is inserted then have an error msgbox. Thanks Jo Sub f() Dim fs Set fs = Application.FileSearch With fs .LookIn = "A:/" .filename = "??????w" If .Execute() 0 Then open_w Else MsgBox "Make sure a disk is inserted and contains a file labelled ??????w" End If End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error Handling - Check a file isn't already open before overwritin | Excel Discussion (Misc queries) | |||
Error handling | Excel Programming | |||
Error Handling | Excel Programming | |||
Error handling | Excel Programming | |||
Error Handling | Excel Programming |