In windows XP I want to make a pdf report from a text file and include a chart - what are my options

I was intending to do it in Excel (VBA), i.e. read in a text file and make a 2 page report, first page with a table and second page with a chart, (first draft attached).  This report I would be triggering automatically so the solution has no operator intervention, and should look after itself.
Unfortunately the PC in question doesn't have Excel, and I don't think I can purchase a version old enough to run on XP (Office 2007 or 2003).
I do have Visual Basic 6 available, but would need some chart objects and a way to save/print to .pdf automatically.
VB6
What is the best way forward?

Thanks
Paul2015-09-21-BrewReport-Example-1.pdf
pau1scottAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Joe Winograd, Fellow&MVEDeveloperCommented:
Hi Paul,
If you prefer the Excel VBA approach, Office 2007 can still be purchased at many places, including Amazon, Rakuten (formerly Buy.com), and, of course eBay, although one must always be careful when buying software on eBay. I'd probably go with Amazon, which may be more expensive, but will be legit. Regards, Joe
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dave BaldwinFixer of ProblemsCommented:
I would look at LibreOffice http://www.libreoffice.org/ or OpenOffice http://www.openoffice.org/ .  Both contain an Excel compatible spreadsheet and PDF output and they're free.
0
pau1scottAuthor Commented:
If I use alternative office apps (I have played with OpenOffice before) I will have to learn the different scripting language, whereas I am experienced in VB/ VBA, and tempted to go with Excel or hack it out in VB6.  
VB6 has the hurdles of making a chart (in the past I have been happier doing line graphs by using the native VB Line function) and getting 2 pages into a .pdf format.
.pdf isn't absolutely required, but I think its the best way to meet the requirement - after the reports are generated, an operator can view them in a directory, select and print a hard copy.  The reports stay on file as a permanent reference.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Joe Winograd, Fellow&MVEDeveloperCommented:
Paul,
With your Excel VBA skills, it seems to me that the easiest approach to get a copy of Office 2007 at Amazon (Standard edition is fine, since all you need is Excel) and then create the PDF with one of the many free PDF print drivers out there, such as Bullzip, CutePDF Writer, or doPDF. Regards, Joe
0
pau1scottAuthor Commented:
Thanks for the suggestion.
0
Joe Winograd, Fellow&MVEDeveloperCommented:
You're welcome. Good luck on the project.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.