FiveTech Software tech support forums

Hi

How and where do you find the value of CONTANTS used in Excel, ex: xlCenter, xlRight,xlAutomatic, etc? I've search in the .CHM files but didn't find them? I'm recording a MACRO and trying to convert them into Fivewin codes. Please help.

Bert

... box that displays a list of all users currently online (by listing the people signed on from USERS.DBF). A button on this dialog box enables recording a message in the memo field of the USER.DBF record of the person selected from the list. Another button enables sending one message to all ...

Try recording a macro. Then record another macro that runs the first macro. Then debug code and you will find something like Application.Run "Book1!Macro1" Maybe this gives you a clue. Unfortunately, this doesn't work either ...

Try recording a macro.
Then record another macro that runs the first macro.
Then debug code and you will find something like
Application.Run "Book1!Macro1"

Maybe this gives you a clue.