Hi,

Every month I run macros which populate the latest months folder. I
wish to run a macro to test whether I have ran this macro yet this
month. So I thought of running a macro that tried to call up a known
file from that folder and if a file is there, a MsgBox returns "Macro
already ran this month".

However if I run it and nothing is there, becuase I asked for the
designated workbook to be there, it will cause a debug error.

How do I get round this (I thought with an If statement)

Thanks in advance :-)

Simon

You can use Dir to test if the file is there

If Dir("C:\Testfolder\ron.xls") <> "" Then
'is there
Else
'not there
End If


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Simon" <(E-Mail Removed)> wrote in message news:d927549e-1f51-4979-bd67-(E-Mail Removed)...
> Hi,
>
> Every month I run macros which populate the latest months folder. I
> wish to run a macro to test whether I have ran this macro yet this
> month. So I thought of running a macro that tried to call up a known
> file from that folder and if a file is there, a MsgBox returns "Macro
> already ran this month".
>
> However if I run it and nothing is there, becuase I asked for the
> designated workbook to be there, it will cause a debug error.
>
> How do I get round this (I thought with an If statement)
>
> Thanks in advance :-)
>
> Simon