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>Bookmarks</TITLE>
<H1>Bookmarks</H1>
<DL><p>
<DT><A
HREF="http://support.microsoft.com/default.aspx?scid=kb;EN-US;306022"
ADD_DATE="1132431077" LAST_VISIT="1210084243" LAST_MODIFIED="1132431077">HOW
TO Transfer Data to an Excel Workbook by Using Visual Basic .NET</A>
<DT><A HREF="http://support.microsoft.com/kb/307216/en-us"
ADD_DATE="1150766024" LAST_VISIT="1210084243" LAST_MODIFIED="1150766024">How
to use Automation with Word 2002</A>
<DT><A HREF="http://support.microsoft.com/?scid=kb;EN-US;317109"
ADD_DATE="1192670692" LAST_VISIT="1210084243"
LAST_MODIFIED="1192670692">Office application does not quit after automation
from Visual Studio .NET client</A>
<DT><A
HREF="http://msdn.microsoft.com/office/default.aspx?pull=/library/en-us/odc_of2003_bk/html/officeinteroperabilitych2_part1.asp"
ADD_DATE="1132431077" LAST_VISIT="1210084243"
LAST_MODIFIED="1132431077">Office Developer Center Chapter 2 (Part 1 of
3)</A>
</DL><p>
<ad**********@googlemail.comwrote in message
news:1a**********************************@s50g2000 hsb.googlegroups.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.