montecas 0 Report post Posted October 3, 2006 Hey everyone, I am trying to write a script to grab data from one window specifically a program used at work to display the sales from the day, and then input that data into an excel workbook. I have no idea where to begin, any help would be greatly appriciated! Share this post Link to post Share on other sites
Kickassjoe 1 Report post Posted October 3, 2006 Search the scripts and scrapts forum for "OCR" (without the quotes) What goes around comes around... Payback's a bitch. Share this post Link to post Share on other sites
Thatsgreat2345 0 Report post Posted October 3, 2006 is it in text or picture format and there is an excel UDF in scripts and scraps Share this post Link to post Share on other sites
Confuzzled 1 Report post Posted October 5, 2006 What is the program that displays the sales called? Does it have a particualr layout on the screen or a report writer interface? Does it use a web browser to see the results? Does it support C.O.M.? You may be able to 'screen scrape' the contents and paste into Excel or pass it through an intermediatary file in something like CSV format. Share this post Link to post Share on other sites
montecas 0 Report post Posted October 5, 2006 The program is a propriety sales tracker, it runs in a comand prompt window. Share this post Link to post Share on other sites
Xenobiologist 35 Report post Posted October 5, 2006 The program is a propriety sales tracker, it runs in a comand prompt window.Hi,take Autoit Window Info to check whether you can read the text.So long,Mega Scripts & functions Organize Includes Let Scite organize the include files Yahtzee The game "Yahtzee" (Kniffel, DiceLion) LoginWrapper Secure scripts by adding a query (authentication) _RunOnlyOnThis UDF Make sure that a script can only be executed on ... (Windows / HD / ...) Internet-Café Server/Client Application Open CD, Start Browser, Lock remote client, etc. MultipleFuncsWithOneHotkey Start different funcs by hitting one hotkey different times Share this post Link to post Share on other sites
Skizmata 0 Report post Posted July 4, 2007 (edited) Hi,take Autoit Window Info to check whether you can read the text.So long,MegaWhat if you can read the text how would you then get it? I need something similar to read a string of numbers out of an AS400 Emulator for work. I need to be able to pull a number from the screen add it to a number I enter in the program and put it back in place of the number I took from the screen.Thanks,-Skizmata Edited July 4, 2007 by Skizmata AutoIt changed my life. Share this post Link to post Share on other sites
