Programming Excel

[Srig007]

I am a newbie at programming in Excel . I have never done this before.
Can someone please lead me to the right direction by suggesting some
reference examples I should look at to start with.

I also would like to know the following: I have Visual Basic.net 2003
edition. Will I be able to program Excel spreadsheets using VB.net.
if no, then please suggest what software I should use. Thanks for
all of your help.


Srig

 

[Bob Phillips]

http://www.mvps.org/dmcritchie/excel/getstarted.htm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Question:

Will I be able to program Excel spreadsheets using VB.net. if no, then
please suggest what software I should use.

Answer:

Yes. You just need to install Visual Studio Tools for Office (VSTO). Here
is a link: http://msdn.microsoft.com/office/tool/vsto/. Make sure you
install the correct one and since your new at it, run through some samples.

After you have VSTO installed, then open your IDE,

1. Select 'File' from the menu bar, then 'New', then 'Project'.
2. In the "New Project" window under 'Project Types' scroll down to
'Microsoft Office System Projects', expand.
3. Choose your language, 'Visual Basic Projects' and then in the right pane
'Templates', select 'Excel Workbook'.

I have multiple languages installed so what I see may differ from what you
see but it should be close enough for you to figure it out.

Have fun!

Kim Greenlee