Report Writing to MS Word Using VB6

I need to write a report in MS Word using VB6 in the below format :

Format :

Page Heading :
"COMPANY NAME" (Page Centre,Font = Bold, Size=14,
Underline)
Sub Heading#1 :
"Something#1" (Page Centre,Font = Bold, Size=12, Underline)
Sub Heading#2 :
"Something#2" (Page Centre,Font = Bold, Size=11, Underline)
Sub Heading#3 :
"Something#3" (Page Centre,Font = Bold, Size=10, Underline)

Inside a "Do while ... Loop"

Data Line # 1
Data Line # 2
Data Line # 3
Data Line # 4
Data Line # 5
Data Line # 6
...

** Report ends here **

Awaiting to hear from any knowledgeable and helpful soul.

Thanks & Rgds
Menon.

Jezebel
Tue Mar 28 22:53:23 CST 2006

What's the question?



"Unni Menon" <Unni Menon@discussions.microsoft.com> wrote in message
news:BF4F7B70-84DF-4AAB-836A-F1862011986F@microsoft.com...
>I need to write a report in MS Word using VB6 in the below format :
>
> Format :
>
> Page Heading :
> "COMPANY NAME" (Page Centre,Font = Bold, Size=14,
> Underline)
> Sub Heading#1 :
> "Something#1" (Page Centre,Font = Bold, Size=12,
> Underline)
> Sub Heading#2 :
> "Something#2" (Page Centre,Font = Bold, Size=11,
> Underline)
> Sub Heading#3 :
> "Something#3" (Page Centre,Font = Bold, Size=10,
> Underline)
>
> Inside a "Do while ... Loop"
>
> Data Line # 1
> Data Line # 2
> Data Line # 3
> Data Line # 4
> Data Line # 5
> Data Line # 6
> ...
>
> ** Report ends here **
>
> Awaiting to hear from any knowledgeable and helpful soul.
>
> Thanks & Rgds
> Menon.
>

UnniMenon
Tue Mar 28 23:21:01 CST 2006

I wanted to "Create a Report" in the below format in MS Word ?
How to do it thru Visual Basic 6 code (program) is the question ?
The database is MS Access which will supply the correct recordset which
is not a problem. Getting the Heading, Sub Heading with the right
formatting as mentioned is the issue ? How to deal with it ?

Thanks & Awaiting to hear your valuable advise.
Menon.
********

"Jezebel" wrote:

> What's the question?
>
>
>
> "Unni Menon" <Unni Menon@discussions.microsoft.com> wrote in message
> news:BF4F7B70-84DF-4AAB-836A-F1862011986F@microsoft.com...
> >I need to write a report in MS Word using VB6 in the below format :
> >
> > Format :
> >
> > Page Heading :
> > "COMPANY NAME" (Page Center,Font = Bold, Size=14,
> > Underline)
> > Sub Heading#1 :
> > "Something#1" (Page Center,Font = Bold, Size=12,
> > Underline)
> > Sub Heading#2 :
> > "Something#2" (Page Center,Font = Bold, Size=11,
> > Underline)
> > Sub Heading#3 :
> > "Something#3" (Page Center,Font = Bold, Size=10,
> > Underline)
> >
> > Inside a "Do while ... Loop"
> >
> > Data Line # 1
> > Data Line # 2
> > Data Line # 3
> > Data Line # 4
> > Data Line # 5
> > Data Line # 6
> > ...
> >
> > ** Report ends here **
> >
> > Awaiting to hear from any knowledgeable and helpful soul.
> >
> > Thanks & Rgds
> > Menon.
> >
>
>
>

Jezebel
Wed Mar 29 00:33:28 CST 2006

Easiest way is to set up a template in Word. Use DocProperty fields for the
matter to go in the header rows. In your VB code, set the properties then
update fields. For the rest, you're just inserting text.




"Unni Menon" <UnniMenon@discussions.microsoft.com> wrote in message
news:7C182DAF-0787-47B0-841A-CA68EBA198B8@microsoft.com...
>I wanted to "Create a Report" in the below format in MS Word ?
> How to do it thru Visual Basic 6 code (program) is the question ?
> The database is MS Access which will supply the correct recordset which
> is not a problem. Getting the Heading, Sub Heading with the right
> formatting as mentioned is the issue ? How to deal with it ?
>
> Thanks & Awaiting to hear your valuable advise.
> Menon.
> ********
>
> "Jezebel" wrote:
>
>> What's the question?
>>
>>
>>
>> "Unni Menon" <Unni Menon@discussions.microsoft.com> wrote in message
>> news:BF4F7B70-84DF-4AAB-836A-F1862011986F@microsoft.com...
>> >I need to write a report in MS Word using VB6 in the below format :
>> >
>> > Format :
>> >
>> > Page Heading :
>> > "COMPANY NAME" (Page Center,Font = Bold, Size=14,
>> > Underline)
>> > Sub Heading#1 :
>> > "Something#1" (Page Center,Font = Bold, Size=12,
>> > Underline)
>> > Sub Heading#2 :
>> > "Something#2" (Page Center,Font = Bold, Size=11,
>> > Underline)
>> > Sub Heading#3 :
>> > "Something#3" (Page Center,Font = Bold, Size=10,
>> > Underline)
>> >
>> > Inside a "Do while ... Loop"
>> >
>> > Data Line # 1
>> > Data Line # 2
>> > Data Line # 3
>> > Data Line # 4
>> > Data Line # 5
>> > Data Line # 6
>> > ...
>> >
>> > ** Report ends here **
>> >
>> > Awaiting to hear from any knowledgeable and helpful soul.
>> >
>> > Thanks & Rgds
>> > Menon.
>> >
>>
>>
>>

UnniMenon
Wed Mar 29 00:48:02 CST 2006

Dear Jezebel,
Thanks your advise n patience.
Can you please advise how same can be done. Do you have some example/
samples of files.

In this case, except "Page Heading", the Content of "Sub Heading#X" changes
i.e.
Sub Heading # 1 will be "Outstanding Report : Period From Date to To Date"
Sub Heading # 2 will be "Export / Import or Other Data"
Sub Heading # 3 will be "Heading of the Display Fields for Data Line"

Can you pls advise step by step.

Thanks & Rgds
Menon.
***********

"Jezebel" wrote:

> Easiest way is to set up a template in Word. Use DocProperty fields for the
> matter to go in the header rows. In your VB code, set the properties then
> update fields. For the rest, you're just inserting text.
>
>
>
>
> "Unni Menon" <UnniMenon@discussions.microsoft.com> wrote in message
> news:7C182DAF-0787-47B0-841A-CA68EBA198B8@microsoft.com...
> >I wanted to "Create a Report" in the below format in MS Word ?
> > How to do it thru Visual Basic 6 code (program) is the question ?
> > The database is MS Access which will supply the correct recordset which
> > is not a problem. Getting the Heading, Sub Heading with the right
> > formatting as mentioned is the issue ? How to deal with it ?
> >
> > Thanks & Awaiting to hear your valuable advise.
> > Menon.
> > ********
> >
> > "Jezebel" wrote:
> >
> >> What's the question?
> >>
> >>
> >>
> >> "Unni Menon" <Unni Menon@discussions.microsoft.com> wrote in message
> >> news:BF4F7B70-84DF-4AAB-836A-F1862011986F@microsoft.com...
> >> >I need to write a report in MS Word using VB6 in the below format :
> >> >
> >> > Format :
> >> >
> >> > Page Heading :
> >> > "COMPANY NAME" (Page Center,Font = Bold, Size=14,
> >> > Underline)
> >> > Sub Heading#1 :
> >> > "Something#1" (Page Center,Font = Bold, Size=12,
> >> > Underline)
> >> > Sub Heading#2 :
> >> > "Something#2" (Page Center,Font = Bold, Size=11,
> >> > Underline)
> >> > Sub Heading#3 :
> >> > "Something#3" (Page Center,Font = Bold, Size=10,
> >> > Underline)
> >> >
> >> > Inside a "Do while ... Loop"
> >> >
> >> > Data Line # 1
> >> > Data Line # 2
> >> > Data Line # 3
> >> > Data Line # 4
> >> > Data Line # 5
> >> > Data Line # 6
> >> > ...
> >> >
> >> > ** Report ends here **
> >> >
> >> > Awaiting to hear from any knowledgeable and helpful soul.
> >> >
> >> > Thanks & Rgds
> >> > Menon.
> >> >
> >>
> >>
> >>
>
>
>

Jezebel
Wed Mar 29 01:22:07 CST 2006

This is all well covered in Help. Step by step instructions here would be
heaping Pelion upon Ossa.





"Unni Menon" <UnniMenon@discussions.microsoft.com> wrote in message
news:D905AB4A-971A-4073-B5AF-2F30B7CA139E@microsoft.com...
> Dear Jezebel,
> Thanks your advise n patience.
> Can you please advise how same can be done. Do you have some example/
> samples of files.
>
> In this case, except "Page Heading", the Content of "Sub Heading#X"
> changes
> i.e.
> Sub Heading # 1 will be "Outstanding Report : Period From Date to To Date"
> Sub Heading # 2 will be "Export / Import or Other Data"
> Sub Heading # 3 will be "Heading of the Display Fields for Data Line"
>
> Can you pls advise step by step.
>
> Thanks & Rgds
> Menon.
> ***********
>
> "Jezebel" wrote:
>
>> Easiest way is to set up a template in Word. Use DocProperty fields for
>> the
>> matter to go in the header rows. In your VB code, set the properties then
>> update fields. For the rest, you're just inserting text.
>>
>>
>>
>>
>> "Unni Menon" <UnniMenon@discussions.microsoft.com> wrote in message
>> news:7C182DAF-0787-47B0-841A-CA68EBA198B8@microsoft.com...
>> >I wanted to "Create a Report" in the below format in MS Word ?
>> > How to do it thru Visual Basic 6 code (program) is the question ?
>> > The database is MS Access which will supply the correct recordset which
>> > is not a problem. Getting the Heading, Sub Heading with the right
>> > formatting as mentioned is the issue ? How to deal with it ?
>> >
>> > Thanks & Awaiting to hear your valuable advise.
>> > Menon.
>> > ********
>> >
>> > "Jezebel" wrote:
>> >
>> >> What's the question?
>> >>
>> >>
>> >>
>> >> "Unni Menon" <Unni Menon@discussions.microsoft.com> wrote in message
>> >> news:BF4F7B70-84DF-4AAB-836A-F1862011986F@microsoft.com...
>> >> >I need to write a report in MS Word using VB6 in the below format :
>> >> >
>> >> > Format :
>> >> >
>> >> > Page Heading :
>> >> > "COMPANY NAME" (Page Center,Font = Bold, Size=14,
>> >> > Underline)
>> >> > Sub Heading#1 :
>> >> > "Something#1" (Page Center,Font = Bold, Size=12,
>> >> > Underline)
>> >> > Sub Heading#2 :
>> >> > "Something#2" (Page Center,Font = Bold, Size=11,
>> >> > Underline)
>> >> > Sub Heading#3 :
>> >> > "Something#3" (Page Center,Font = Bold, Size=10,
>> >> > Underline)
>> >> >
>> >> > Inside a "Do while ... Loop"
>> >> >
>> >> > Data Line # 1
>> >> > Data Line # 2
>> >> > Data Line # 3
>> >> > Data Line # 4
>> >> > Data Line # 5
>> >> > Data Line # 6
>> >> > ...
>> >> >
>> >> > ** Report ends here **
>> >> >
>> >> > Awaiting to hear from any knowledgeable and helpful soul.
>> >> >
>> >> > Thanks & Rgds
>> >> > Menon.
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>