How i use Excell worksheet in VB.net?

[hamadsultan]

Hi experts;
I have a excell worksheet which have a addins also. I want to use these sheet in Vb.net. But the problem is every time when i open the worksheet it ask to enable the macro. How i set its configration permanently that never as to enable macro and ask for the password as well when i click to enable macro? I want that before calling these sheets in VB.net i solved these problems.
I use office 2007.
Regards

 

[RichardMGreen]

You could set the macro secrurity level to low which will automatically enable the macros.
You could also, when opening the workbook, pass the password as a parameter which should solve that section as well.

 

[Ruddles]

Or to disable macros, after creating the Excel application, set its .EnableEvents property to False before you open the workbook.

 

[hamadsultan]

Hi;
How i pass the password from vb.net to excell worksheet?
What is the syntax?

 

[RichardMGreen]

In Excel VBA it would be:-
workbook,name, Password:="xxx"
where xxx is your password.

You can use a variable for this if you're opening multiple files with different passwords.

 

[Ruddles]

It might be easier to advise you if we could see the code you're using to start Excel and open the workbook. Please post this between CODE tags - the # icon in the advanced editor toolbar - and be sure to include all the relevant declarations.