C# to Word and Excel and Outlook

[M K]

I would like to write code to export to excel, outlook and word. Any idea
where a good resource to look? I know about using the VBA macros as I have
done that in lotus notes ( but that is VB to VB for the most part).

Do I use VBA? or is there a C# version of that?
What extentions do I need to load?
Any good code samples to get me started?

Thanks
Mark

 

[Rad [Visual C# MVP]]

I would like to write code to export to excel, outlook and word. Any idea
where a good resource to look? I know about using the VBA macros as I have
done that in lotus notes ( but that is VB to VB for the most part).

Do I use VBA? or is there a C# version of that?
What extentions do I need to load?
Any good code samples to get me started?

Thanks
Mark

You'd get a lot more help if you explained what sort of data you are
looking to export.

What do you mean, for instance, export to outlook?

 

[M K]

what i want to do is create reports in excel and word and maybe use outlook
to send email (using a field stored in my app) and create contacts and
possibly save things to a folder.

Its more or less to learn how to do it in hopes to obtain a job in .net at
some point before I die . Very hard to get a job with only @ home
experience and everyone is looking for experience (i have a ton of VB/VB.net
and Lotus Notes which I am trying to get out of). So its hard for me to
find a job or even close to a seasoned .net developers salary having been in
Lotus Notes for over 12 years. Its sort of a dead end street in the area I
live in and since I cant get a job this is my only hope.. create apps to
showcase my skills... unless someone has a better suggestion.. im all ears

Thanks,
Mark

 

[M K]

another caviat is that I have done some VBA in Lotus Notes to both word and
excel. So to answer your question about the type of data.. All types, text,
numbers, dates etc...

I have written some reuseable code in Lotus Notes so I am curious what it
would look like in .net. (tables on word docs, colors, fonts and the like
and imbedded icons and formatting spread sheets for reports.. data dumps)

 

[Egghead]

Actually, I believe the first q is : do you need the Word and Excel
installed at the PC?

 

[Mark Rae [MVP]]

what i want to do is create reports in excel and word

Several options for that:
http://www.microsoft.com/downloads/...52-3547-420a-a412-00a2662442d9&displaylang=en
http://msdn2.microsoft.com/En-US/library/aa338205.aspx
http://www.microsoft.com/downloads/...80-f2c0-4b80-9ad1-2cb0c300aef9&displaylang=en
http://www.aspose.com/Products/Default.aspx

and maybe use outlook to send email

There's no requirement to use Outlook (or any other mail client) to send
email from .NET apps:
http://www.systemnetmail.com/faq/1.3.aspx

However, if you want to use Office Automation, it's all available for you:
http://www.microsoft.com/downloads/...3a-ac14-4125-8ba0-d36d67e0f4ad&displaylang=en
http://www.microsoft.com/downloads/...aa-bed4-4282-a28c-b864d8bfa513&displaylang=en

 

[Mark Rae [MVP]]

Actually, I believe the first q is : do you need the Word and Excel
installed at the PC?

Absolutely not! See my previous reply...

 

[Egghead]

If he does not want the office at the PC, he better use 3rd party ctl. XML
Word doc only work at office 2K7.
If the office is installed, it is mickey to have that. Google is your
friend.

 

[Mark Rae [MVP]]

If he does not want the office at the PC, he better use 3rd party ctl. XML
Word doc only work at office 2K7.
If the office is installed, it is mickey to have that. Google is your
friend.

I couldn't have put it better myself...

 

[M K]

Yes I have office installed and thanks for the links I will check them out.

If you read one of my previous posts this is all for education only and
nothing more. I don't plan on distributing my app at all.
Thanks for your help

 

[Alvin Bruney [MVP]]

I have found that if you are willing to cut your asking price significantly
and show the right attitude, an employer will usually take you in. Have you
tried that?

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
https://www.microsoft.com/MSPress/books/10933.aspx
OWC Black Book www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley

Yes I have office installed and thanks for the links I will check them
out.

If you read one of my previous posts this is all for education only and
nothing more. I don't plan on distributing my app at all.
Thanks for your help