vb help

  • Thread starter Thread starter Hal
  • Start date Start date
H

Hal

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
 
Can we do it in VBA?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Toolbar 1
Control Excel from Access 2
Control Excel from Access 4
VB Code 10
Run macro from active workbook whose name keeps changing 20
Macro Help 4
Copy Data from Closed File to Existing File 0
End of Word Document and Append from Excel VB 1

Back
Top