Please help compilC# Excel integration code

Dear Friends,

I am not sure what is wrong with the code at the followijng web address, but the code is not compiling with VS 2008. Can someone pleaese look into this?

The code is located at http://support.microsoft.com/kb/303872.

Appreciate your help,

Thanks,
AMita
deoyagyaAsked:
Who is Participating?
 
wdosanjosConnect With a Mentor Commented:
Please try the following.  I was able to compile here (VS2008, .NET 3.5, Excel 2007).

oCommandBar = oExcel.CommandBars.Add("VBAMacroCommandBar", oMissing, oMissing, oMissing);
0
 
wdosanjosCommented:
What error message do you get and in what line?
0
 
Éric MoreauSenior .Net ConsultantCommented:
And which edition of VS are you using? I don't think the express edition can use it.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
deoyagyaAuthor Commented:
I am using Visual Studio 2008. I am getting the error message at the following line of the code:

            oCommandBar = oExcel.CommandBars.Add("VBAMacroCommandBar",oMissing, oMissing,\);

This is giving me error related to new line character.
0
 
Todd GerbertIT ConsultantCommented:
That's a mal-formed statement - you're passing a backslash as the last parameter, which is not valid.
0
 
deoyagyaAuthor Commented:
Can you give me the working code then.
0
 
wdosanjosCommented:
Try this:

oCommandBar = oExcel.CommandBars.Add("VBAMacroCommandBar",oMissing, oMissing,);
0
 
wdosanjosCommented:
Sorry I meant,

oCommandBar = oExcel.CommandBars.Add("VBAMacroCommandBar",oMissing, oMissing);
0
 
deoyagyaAuthor Commented:
I tried this. But this is not working. I am getting the error message "Add method takes three arguments".
0
 
deoyagyaAuthor Commented:
Thanks a lot for the help. This is working fine now.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.