Prev: A1-B1-C1=D1 BU FORMÜLÜ İSTİYORUM
Next: Macro that can sort out a variabel name among others in a row and
From: Abhishek - Oracle Abhishek - on 18 Feb 2010 17:03
Is there a way to start excel in "safe mode" programmatically.

I am creating an excel application instance as mentioned below:-

Excel.Application excelApp = new Excel.Application ();

I do not want to load add-ins and it's my understanding that the "safe mode"
suppresses all add-ins.

Also, I do not want to affect any other instances of the excel application
which may be running add-ins.

Please advise.

Thanks,
Abhishek
From: Dave Peterson on 18 Feb 2010 17:15
When I start an excel instance using MSWord, I have to load the addins that I
want to use--since none are loaded when I start Excel this way.

It's not quite safe mode--I still have to disable events in excel before I
open/change/close stuff.

Isn't that what you're seeing with your code and your new excel application?





Abhishek - Oracle wrote:
>
> Is there a way to start excel in "safe mode" programmatically.
>
> I am creating an excel application instance as mentioned below:-
>
> Excel.Application excelApp = new Excel.Application ();
>
> I do not want to load add-ins and it's my understanding that the "safe mode"
> suppresses all add-ins.
>
> Also, I do not want to affect any other instances of the excel application
> which may be running add-ins.
>
> Please advise.
>
> Thanks,
> Abhishek

--

Dave Peterson
From: Homey on 19 Feb 2010 07:06
maybe see this work ok

Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _
(ByVal hRegEdit As Long, ByVal lpOperation As String, _
ByVal lpFile As String, ByVal lpParameters As String, _
ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long

Sub StartXLSafemode()
ShellExecute 0, "Open", "excel.exe", "/s", "", 1
End Sub

"Abhishek - Oracle" <Abhishek - Oracle(a)discussions.microsoft.com> wrote in
message news:4A361F38-A330-4814-B839-E9BBDA9236B8(a)microsoft.com...
| Is there a way to start excel in "safe mode" programmatically.
|
| I am creating an excel application instance as mentioned below:-
|
| Excel.Application excelApp = new Excel.Application ();
|
| I do not want to load add-ins and it's my understanding that the "safe
mode"
| suppresses all add-ins.
|
| Also, I do not want to affect any other instances of the excel application
| which may be running add-ins.
|
| Please advise.
|
| Thanks,
| Abhishek

From: Abhishek - Oracle on 19 Feb 2010 19:43
Thanks a lot for the suggestion.

I got something working using the code below :-

Systen.Diagnostics.Process myProcess = new Process ();
myProcess.StartInfo.FileName = "excel.exe";
myProcess.StartInfo.Arguments = "/safemode";
myProcess.StartInfo.WindowStyle = ProcessWindowStyle.Hidden;
myProcess.StartInfo.CreateNoWindow = true;
myProcess.Start ();

I can run excel in safe mode as needed.

Now the only thing left is to get the Excel.Application instance from the
above process "myProcess".

I am trying "System.Runtime.InteropServices.Marshal.GetActiveObject" or
"System.Runtime.InteropServices.Marshal.BindToMoniker" without any success so
far.
Any ideas are welcome.

Thanks
Abhishek

"Homey" wrote:

> maybe see this work ok
>
> Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _
> (ByVal hRegEdit As Long, ByVal lpOperation As String, _
> ByVal lpFile As String, ByVal lpParameters As String, _
> ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
>
> Sub StartXLSafemode()
> ShellExecute 0, "Open", "excel.exe", "/s", "", 1
> End Sub
>
> "Abhishek - Oracle" <Abhishek - Oracle(a)discussions.microsoft.com> wrote in
> message news:4A361F38-A330-4814-B839-E9BBDA9236B8(a)microsoft.com...
> | Is there a way to start excel in "safe mode" programmatically.
> |
> | I am creating an excel application instance as mentioned below:-
> |
> | Excel.Application excelApp = new Excel.Application ();
> |
> | I do not want to load add-ins and it's my understanding that the "safe
> mode"
> | suppresses all add-ins.
> |
> | Also, I do not want to affect any other instances of the excel application
> | which may be running add-ins.
> |
> | Please advise.
> |
> | Thanks,
> | Abhishek
>
> .
>
 | 
Pages: 1
Prev: A1-B1-C1=D1 BU FORMÜLÜ İSTİYORUM
Next: Macro that can sort out a variabel name among others in a row and