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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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
All Courses

From novice to tech pro — start learning today.