Jump to content
Macro Express Forums

sri

Members
  • Posts

    2
  • Joined

  • Last visited

Posts posted by sri

  1. The best place to start is with the Help pages:

     

    Macro Express Editor -> Help -> Tutorial

     

    We're certainly happy to help, but most of the help we could give you in this forum depends on you having at least a very very basic

    understanding of how Macro Express operates. If you have a very specific question we can help you with it, but as far as explaining how to write

    macro code in ME... the Help pages will be more clear than we could be.

     

    Essentially, though, what you'll want to do is build a macro that activates Excel (or which processes the information from an Excel file - much

    more advanced, though simpler process) and copies the information from the cells in question, saving them each to different variables. You'll

    then want to convert the variables from Text variables to either Integer variables or Decimal variables, and then use the modify variable

    function to add the information together.

     

    Then simply save them as a Word document.

     

    If you aren't familiar with even the Help pages, that probably sounded like a lot of trouble, but if you have been through the Tutorials, then you

    probably understood at least some of it, and it really isn't too bad at all.

     

    Here's a very basic example of what you probably want to do (keep in mind, this is extraordinarily basic, and there are shorter, possibly better

    ways to do this, but they require a bit more experience to fully grasp them):

    Activate Window: "Excel"
    Delay 0.25 Seconds
    Text Box Display: Click
    Wait Left Mouse Click
    Delay 0.25 Seconds
    Clipboard Copy
    Variable Set String %T1% from Clipboard
    Text Box Display: Click
    Wait Left Mouse Click
    Delay 0.25 Seconds
    Clipboard Copy
    Variable Set String %T2% from Clipboard
    Variable Modify String: Convert %T1% to decimal %D1%
    Variable Modify String: Convert %T2% to decimal %D2%
    Variable Modify Decimal: %D3% = %D1% + %D2%
    Variable Modify Decimal: Convert %D3% to text string %T3%
    Variable Modify String: Save %T3% to Text File

     

    Give the Tutorial a shot, play around with Macro Express a little and get familiar with how it works and you'll be a wiz in no time. If you run into

    a stumbling block, we'll be happy to help you through it.

     

     

    Thank You

×
×
  • Create New...