Programming Excel

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

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

--
HTH

Bob Phillips

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

"Srig007" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> Srig007
> ------------------------------------------------------------------------
> Srig007's Profile:
http://www.excelforum.com/member.php...o&userid=36705
> View this thread: http://www.excelforum.com/showthread...hreadid=564381
>

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

--
HTH

Bob Phillips

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

"Srig007" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> Srig007
> ------------------------------------------------------------------------
> Srig007's Profile:
http://www.excelforum.com/member.php...o&userid=36705
> View this thread: http://www.excelforum.com/showthread...hreadid=564381
>

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

--
digipede - Many legs make light work.
Grid computing for the real world.
http://www.digipede.net
http://krgreenlee.blogspot.net