Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create Word (or Excel) Reports via VBA
I need to create some reports. I had planned to use Crystal Reports and
store the information in a SQL Database. However, the more I use advanced techniques in creating this Excel application, I see that it is possible to create reports in Word or Excel using VBA. I would like it if someone could point me in the right direction to creating a report in Word. Excel would work as long as it looks professional. The application that I have written gets comments from the users and creates charts. 1) I will create a header page 2) Insert the comments 3) Insert the appropriate chart images (gif files) 4) go to the next section (4 sections in all) 5) Need to add the patient number to the header 6) Create some page numbers in the footer Can anyone show me an example or at least point me to a knowledge base or article dealing with creating reports via VBA? Thanks, Tony |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create Word (or Excel) Reports via VBA
On Thu, 19 Feb 2009 14:04:10 -0800, Webtechie
wrote: I need to create some reports. I had planned to use Crystal Reports and store the information in a SQL Database. However, the more I use advanced techniques in creating this Excel application, I see that it is possible to create reports in Word or Excel using VBA. I would like it if someone could point me in the right direction to creating a report in Word. Excel would work as long as it looks professional. The application that I have written gets comments from the users and creates charts. 1) I will create a header page 2) Insert the comments 3) Insert the appropriate chart images (gif files) 4) go to the next section (4 sections in all) 5) Need to add the patient number to the header 6) Create some page numbers in the footer Can anyone show me an example or at least point me to a knowledge base or article dealing with creating reports via VBA? Tony: This article may help some http://www.dailydoseofexcel.com/arch...tomating-word/ -- Dick Kusleika Microsoft MVP-Excel http://www.dailydoseofexcel.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Reports from Excel data to Word | Excel Discussion (Misc queries) | |||
How to create org chart from excel file with reports to column | Charts and Charting in Excel | |||
Import cells from excel into word and create multiple word docs | Excel Programming | |||
Create Excel SS from Crystal Reports | Excel Discussion (Misc queries) | |||
Excel to generate reports in Word | Excel Programming |