[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

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
0
deoyagya
Asked:
deoyagya
1 Solution
 
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
 
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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
 
wdosanjosCommented:
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
 
deoyagyaAuthor Commented:
Thanks a lot for the help. This is working fine now.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now