Link to home
Start Free TrialLog in
Avatar of deoyagya
deoyagya

asked on

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
Avatar of wdosanjos
wdosanjos
Flag of United States of America image
What error message do you get and in what line?
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image
And which edition of VS are you using? I don't think the express edition can use it.
Avatar of deoyagya
deoyagya

ASKER

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.
Avatar of Todd Gerbert
Todd Gerbert
Flag of United States of America image
That's a mal-formed statement - you're passing a backslash as the last parameter, which is not valid.
Avatar of deoyagya
deoyagya

ASKER

Can you give me the working code then.
Avatar of wdosanjos
wdosanjos
Flag of United States of America image
Try this:

oCommandBar = oExcel.CommandBars.Add("VBAMacroCommandBar",oMissing, oMissing,);
Avatar of wdosanjos
wdosanjos
Flag of United States of America image
Sorry I meant,

oCommandBar = oExcel.CommandBars.Add("VBAMacroCommandBar",oMissing, oMissing);
Avatar of deoyagya
deoyagya

ASKER

I tried this. But this is not working. I am getting the error message "Add method takes three arguments".
ASKER CERTIFIED SOLUTION
Avatar of wdosanjos
wdosanjos
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of deoyagya
deoyagya

ASKER

Thanks a lot for the help. This is working fine now.