sri Posted March 7, 2009 Report Share Posted March 7, 2009 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 Quote Link to comment Share on other sites More sharing options...
stevecasper Posted March 10, 2009 Report Share Posted March 10, 2009 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. Quote Link to comment Share on other sites More sharing options...
sri Posted March 11, 2009 Author Report Share Posted March 11, 2009 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.