Developing a selection program

[adrianmepham@googlemail.com]

Hi group,

I have been given the task at work of producing a selection frogram
for a range of our air handling units. I have a little experience of
programing in VB 6 from many years ago, but would like to try and
attempt this in VB.net and make as good a job as possible of it. The
application will be required to output schedules and reports in both
Excel and Word documents . What I am asking is, has anyone done
anything like this and could give me some advice on how to go about
it. I have bought a few well reviewed books but have not come across
any mention of Word or Excel documents being prduced in VB.net. Any
advice, tips or alternative coding language to use will be gratefully
received.

Thank you.

Adrian.

[Cor Ligthert[MVP]]

Re: Developing a selection program

Adrian ,

You don't know something more difficult to start with, as I was you, I would
first start with a simple windowforms program.

However just my idea,

Cor

<adrianmepham@g ooglemail.comsc hreef in bericht
news:1ae8d120-e9e2-414d-9544-e869ef8a880a@s5 0g2000hsb.googl egroups.com...

Hi group,
>
I have been given the task at work of producing a selection frogram
for a range of our air handling units. I have a little experience of
programing in VB 6 from many years ago, but would like to try and
attempt this in VB.net and make as good a job as possible of it. The
application will be required to output schedules and reports in both
Excel and Word documents . What I am asking is, has anyone done
anything like this and could give me some advice on how to go about
it. I have bought a few well reviewed books but have not come across
any mention of Word or Excel documents being prduced in VB.net. Any
advice, tips or alternative coding language to use will be gratefully
received.
>
Thank you.
>
Adrian.

[eBob.com]

Re: Developing a selection program

Below are some links to some documentation (exported from my Favorites).
None, as I recall, is very complete. But each has been helpful to me to
some extent.

I have a VB.Net program which produces an Excel spreadsheet. But finding
decent documentation has been a real problem. Finding help has been
difficult too. There evidently must be few people doing this. But I have
looked for help mostly in newsgroups. Maybe more help would be available in
the many VB.Net fora. (Although in general I have found this newsgroup to
be an EXCELLENT source of help!)

I'll share any of my code with you,but note that it only does the basics and
is probably not industrial strength.

If I am recalling correctly I came across a book a while back which looked
like it would be helpful. But I just now looked on Amazon and did not find
anything which looked useful.

Good Luck, Bob

<!DOCTYPE NETSCAPE-Bookmark-file-1>
<!-- This is an automatically generated file.
It will be read and overwritten.
Do Not Edit! -->
<TITLE>Bookmark s</TITLE>
<H1>Bookmarks </H1>
<DL><p>
<DT><A
HREF="http://support.microso ft.com/default.aspx?sc id=kb;EN-US;306022"
ADD_DATE="11324 31077" LAST_VISIT="121 0084243" LAST_MODIFIED=" 1132431077">HOW
TO Transfer Data to an Excel Workbook by Using Visual Basic .NET</A>
<DT><A HREF="http://support.microso ft.com/kb/307216/en-us"
ADD_DATE="11507 66024" LAST_VISIT="121 0084243" LAST_MODIFIED=" 1150766024">How
to use Automation with Word 2002</A>
<DT><A HREF="http://support.microso ft.com/?scid=kb;EN-US;317109"
ADD_DATE="11926 70692" LAST_VISIT="121 0084243"
LAST_MODIFIED=" 1192670692">Off ice application does not quit after automation
from Visual Studio .NET client</A>
<DT><A
HREF="http://msdn.microsoft. com/office/default.aspx?pu ll=/library/en-us/odc_of2003_bk/html/officeinteroper abilitych2_part 1.asp"
ADD_DATE="11324 31077" LAST_VISIT="121 0084243"
LAST_MODIFIED=" 1132431077">Off ice Developer Center Chapter 2 (Part 1 of
3)</A>
</DL><p>


<adrianmepham@g ooglemail.comwr ote in message
news:1ae8d120-e9e2-414d-9544-e869ef8a880a@s5 0g2000hsb.googl egroups.com...

Hi group,
>
I have been given the task at work of producing a selection frogram
for a range of our air handling units. I have a little experience of
programing in VB 6 from many years ago, but would like to try and
attempt this in VB.net and make as good a job as possible of it. The
application will be required to output schedules and reports in both
Excel and Word documents . What I am asking is, has anyone done
anything like this and could give me some advice on how to go about
it. I have bought a few well reviewed books but have not come across
any mention of Word or Excel documents being prduced in VB.net. Any
advice, tips or alternative coding language to use will be gratefully
received.
>
Thank you.
>
Adrian.

[Lauren]

Re: Developing a selection program

I have worked on a similar project for the last several years. We used
Vecad as the cad engine and did some output to Word and Excel. We have not
yet ported the program to .Net however. If your product is very custom this
could become a very complex project very quickly. Get the real long term
scope defined and spend the time to think though a good design for the app
up front.
Lauren


<adrianmepham@g ooglemail.comwr ote in message
news:1ae8d120-e9e2-414d-9544-e869ef8a880a@s5 0g2000hsb.googl egroups.com...

Hi group,
>
I have been given the task at work of producing a selection frogram
for a range of our air handling units. I have a little experience of
programing in VB 6 from many years ago, but would like to try and
attempt this in VB.net and make as good a job as possible of it. The
application will be required to output schedules and reports in both
Excel and Word documents . What I am asking is, has anyone done
anything like this and could give me some advice on how to go about
it. I have bought a few well reviewed books but have not come across
any mention of Word or Excel documents being prduced in VB.net. Any
advice, tips or alternative coding language to use will be gratefully
received.
>
Thank you.
>
Adrian.

[mario@gemboxsoftware.com]

Re: Developing a selection program

Hi,

You can use Office Automation to export data to Excel or Word. Other
option is to use some third party component. I recommend
GemBox.Spreadsh eet for exporting/importing data from Excel files
(Automation has some problems - http://www.gemboxsoftware.com/GBSpre...tm#Automation).

--
Mario
GemBox.Spreadsh eet for .NET - Easily read and write Excel (XLS, XLSX
or CSV)
or export to HTML files from your .NET apps. See

http://www.gemboxsoftware.com/GBSpreadsheet.htm

On May 6, 9:47 am, adrianmep...@go oglemail.com wrote:

Hi group,
>
I have been given the task at work of producing a selection frogram
for a range of our air handling units. I have a little experience of
programing in VB 6 from many years ago, but would like to try and
attempt this in VB.net and make as good a job as possible of it. The
application will be required to output schedules and reports in both
Excel and Word documents . What I am asking is, has anyone done
anything like this and could give me some advice on how to go about
it. I have bought a few well reviewed books but have not come across
any mention of Word or Excel documents being prduced in VB.net. Any
advice, tips or alternative coding language to use will be gratefully
received.
>
Thank you.
>
Adrian.