Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to start excel in "safe mode" programmatically
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to start excel in "safe mode" programmatically
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to start excel in "safe mode" programmatically
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 - wrote in message ... | 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to start excel in "safe mode" programmatically
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.GetActiveO bject" or "System.Runtime.InteropServices.Marshal.BindToMoni ker" 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 - wrote in message ... | 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Start Windows in Safe Mode | Excel Discussion (Misc queries) | |||
Make "Edit" mode default, rather than "Enter"? | Excel Discussion (Misc queries) | |||
Excel "mode" function returns different results based on sort orde | Excel Worksheet Functions | |||
Merge worksheets in "Share Mode" (Excel 2000) | Excel Programming |