Excel to Word automation

D

Dave F

I am working with a client that currently dumps data from a program called
PerTrac into an Excel sheet.
This information is then manipulated several ways some by manual updating in
the target document (currently Publisher) sometimes copy and paste etc.
This seems archaic to me at best.
I am not a developer by any means but I know Office has the capability of
doing some amazing things.

There has got to be a better way of creating and updating these documents
than this 'stone and chisel' approach.

Anyone have any great ideas?
VB?
XML?
Simple OLE?

I'm open to any and all suggestions.

David French
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automation of scanned file storage based on content 0
Integrating information from Word to Excel (not mail merge) 1
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Linking data in MS Word into Excel 5
Link Excel to word 2
Auto-Numbering in a Table in MS Word 1
Automating an Office app (Word, Excel, etc) from webpage 0
Can't save my Office documents (after computer rebuild and reauthorization) 0

Top