Jump to content
Macro Express Forums

New to macro Express


sri
 Share

Recommended Posts

Hi Team,

 

I am new to macro express , I want to get two values from excel and add them, store the result in Word. How to write code in ME.

 

Thanks

Sridhar

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...