Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Word document reporting

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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default Word document reporting

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


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Word document reporting

On Friday, July 6, 2012 10:29:56 AM UTC-4, GS wrote:
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


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.
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default Word document reporting

laid this down on his screen :
On Friday, July 6, 2012 10:29:56 AM UTC-4, GS wrote:
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


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


Reply
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
convert excel document to word document (not a picture) frendabrenda1 Excel Discussion (Misc queries) 2 October 6th 06 03:55 PM
Changing a Word Document to a CSV Formated Document Team1 New Users to Excel 3 February 6th 06 11:29 PM
How do I convert a word document into a Excel document gwiltz2 Excel Discussion (Misc queries) 1 October 22nd 05 07:04 PM
How to change a excel document into a word document? wannaknow Excel Discussion (Misc queries) 1 July 27th 05 09:37 PM
How do I convert Word document into an Excel document? Jamie Excel Discussion (Misc queries) 3 April 7th 05 09:45 PM


All times are GMT +1. The time now is 11:40 PM.

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"