Word document reporting

[goshute]

What can I use to create nice looking documents.

We were storing data in Excel worksheets and using it to fill out an
Excel form. The data was then sent to a word document for printing and
creating pdf's. Now our entire company is going to Google docs except
for a few users that will still have Excel.

Word was used for the reports because it is easy to format a clean
looking document with correct page breaks, headers, rooters, etc, but
now it is being uninstalled.

We have tried inserting the data into another worksheet and printing
that but Excel is not suited for this.

 

[GS]

goshute explained :

What can I use to create nice looking documents.

We were storing data in Excel worksheets and using it to fill out an
Excel form. The data was then sent to a word document for printing and
creating pdf's. Now our entire company is going to Google docs except
for a few users that will still have Excel.

Word was used for the reports because it is easy to format a clean
looking document with correct page breaks, headers, rooters, etc, but
now it is being uninstalled.

We have tried inserting the data into another worksheet and printing
that but Excel is not suited for this.

There is very little you can do in Word that can't be duplicated in
Excel. Why can't you set pagebreaks and print to PDF directly from
Excel? I create entire manuals this way that include dozens of images,
numerous tables, and numbered paragraphs, all output to PDFs without
problems. No reason you need to use Word at all, IMO!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[thompson759]

goshute explained :

There is very little you can do in Word that can't be duplicated in
Excel. Why can't you set pagebreaks and print to PDF directly from
Excel? I create entire manuals this way that include dozens of images,
numerous tables, and numbered paragraphs, all output to PDFs without
problems. No reason you need to use Word at all, IMO!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

I agree that it is utimately possible, but we have been programming for three weeks to address the variables that were once addressed with a simple Word template. There seems to be no end in sight and the users and I are becoming frustrated with the Excel worksheet method.

 

[GS]

(e-mail address removed) laid this down on his screen :

I agree that it is utimately possible, but we have been programming for three
weeks to address the variables that were once addressed with a simple Word
template. There seems to be no end in sight and the users and I are becoming
frustrated with the Excel worksheet method.

I understand the frustration. I use template worksheets for the docs I
create and so the 'learning curve' is zero. I prefer to use Excel for
publishing Excel data because (for me) it's just simpler. I guess the
challenge is to surpass the hurdle of using Excel in place of Word. I'm
not sure why you think you need to "insert the data into another
worksheet and printing that..." when you should be able to print the
original sheet. I totally disagree with "..but Excel is not suited for
this."!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion