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.
What is the best way forward?

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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, 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

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 or OpenOffice .  Both contain an Excel compatible spreadsheet and PDF output and they're free.
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.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Joe Winograd, Fellow&MVEDeveloperCommented:
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
pau1scottAuthor Commented:
Thanks for the suggestion.
Joe Winograd, Fellow&MVEDeveloperCommented:
You're welcome. Good luck on the project.
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.