Jump to content
Sign in to follow this  
farhan86a

Copying a Number, Performing basic Mathematical Operations and Pasting

Recommended Posts

farhan86a

Hi,

I have semi auto-mated a task that generates random numbers in excel. However, I now need to perform basic mathematical operations on those numbers and paste them lets say on a notepad. To put it in steps, here is what I intend to achieve:

  • To Copy a number from Excel (it can be from any other application too such as Word or even Notepad)
  • Store it somewhere in my AutoIT application
  • Perform basic mathematical operations on this stored number
  • Paste the new number in Notepad (or any other document processing application)
I know how to get the number copied from Excel by just sending (Ctrl+C) but I don't know where to store or bring it to AutoIT for further processing and then pasting it say on notepad. I would really be glad if somebody can show me some ray of hope. :graduated:

Share this post


Link to post
Share on other sites
farhan86a

Well I did it. But I know it is an alternative. I automated the entire process by copying and pasting it to calculator and then copying and pasting the numbers wherever I intend to. Can someone guide to a much easier solution? Thanks to those who gave it a look!

Cheers!

Share this post


Link to post
Share on other sites
BrewManNH

If you just need a random number, look at the Random() function, unless there's a burning need to use an external program for this.


If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.
Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag Gude
How to ask questions the smart way!

I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from.

Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays.  -  ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script.  -  Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label.  -  _FileGetProperty - Retrieve the properties of a file  -  SciTE Toolbar - A toolbar demo for use with the SciTE editor  -  GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI.  -   Latin Square password generator

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×