I have the following line in my macro: Windows("rep.xls").Activate
I want to have a message box appear if the file is not open to say "please
open rep.xls"
I dont want the macro to open the file as the user will need to run another
macro to create it.
using xlm the code it would read:
=ERROR(FALSE)
=ACTIVATE("rep.xls")
=IF(A2=FALSE)
=ALERT("Please open rep.xls")
=END.IF()
=ERROR(TRUE)

Could anybody let me know the vb code for the above
Many Thanks
Hal