How do I format a MSGBOX to show text and variables in a macro?
I have a macro that receives a variable that is input by a user (&rsp1)
I want a MsgBox to display €œDo you want to print off the data for €œand the
variable &rsp1.
The MsgBox lookes like:-
MsgBox "Do you want to print off the data for &rsp1 - 1?", vbYesNo, "Do you
want to Print off€
Additionally, if I know the location of a particular file, how do I
incorporate an open to it?
Any assistance offered will be appreciated.
|