LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default Summarizing Large Reports

Our company's computer system can generate sales reports, but only in
PDF. I'd like to be able to see the sales data in Excel.

Maybe this was the wrong direction, but I was trying to use AutoIt to
run script-macros to translate the data. Info on AutoIt is at
http://www.autoitscript.com/autoit3


Starting with a PDF file that contains sales data
(example) Sales Report in PDF
http://dressindustrial.com/geogb8341.pdf

I can use an Online PDF to plain text converter to turn the PDF into
a text file Excel can read
http://dressindustrial.com/geogb8341.txt

The next step is to reformat that text into an
Excel File with Sales Data
http://dressindustrial.com/geogb8341.xls



I'm hoping that someone can help roll this all together, from PDF to
Excel. Any info you have to contribute would be GREAT advise



you can see the autoit script that I was working on at
http://dressindustrial.com/test.au3

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Summarizing Data John Excel Worksheet Functions 2 January 29th 09 07:13 PM
Why are large reports truncated in Excel? ALPost95Adj Excel Discussion (Misc queries) 1 October 26th 08 01:45 AM
How to export large amounts of text data into single reports Wayne Excel Discussion (Misc queries) 1 May 23rd 08 11:44 PM
EPM REPORTS - Exporting 2007 excel reports to 2003 excel report Prashanthi Setting up and Configuration of Excel 0 February 18th 08 03:02 PM
help with summarizing Jesper[_2_] Excel Programming 0 July 19th 04 11:51 AM


All times are GMT +1. The time now is 06:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"