Prev: Running formulas with data from mulitple workbooks
Next: SaveAs *.txt - Outputting with Text quantifiers
From: Domenick on 20 May 2010 15:56
Anyone know how to launch excel from a command line with a /switch that will
cause excel to NOT launce personal.xls?

From: Dave Peterson on 20 May 2010 16:25
You could start excel in safe mode:
excel /safe

You can search excel's help for: Customize how Excel starts

or
Description of the startup switches for Excel
http://support.microsoft.com/kb/291288

Domenick wrote:
>
> Anyone know how to launch excel from a command line with a /switch that will
> cause excel to NOT launce personal.xls?

--

Dave Peterson
From: Peter T on 21 May 2010 06:05
Another approach might be to start Excel as an automated instance, which
means no startup workbooks will load, not even addin workbooks. You could do
that from an already running instance of Excel, or from a simple vbs script,
eg

with createobject("excel.application")
..visible = true
..workbooks.add
end with

from a text editor like Notepad save as say "EmptyExcel.vbs"

FWIW, unlike starting in safe mode, this way would start Excel with full
customized toolbars

Regards,
Peter T

"Domenick" <Domenick(a)discussions.microsoft.com> wrote in message
news:E34F0D82-DCAB-4B74-B3AF-573E328CC740(a)microsoft.com...
> Anyone know how to launch excel from a command line with a /switch that
> will
> cause excel to NOT launce personal.xls?
>


From: Domenick on 21 May 2010 14:09
Well, starting in safe mode DOES keep personal.xls from loading.
Unfortunately, starting in safe mode does not allow my workbook_open event to
run either. I all kinds of macro security errors. I guess running in safe
mode disables all of the "trusted locations" in the trust center? Any other
ideas?

"Dave Peterson" wrote:

> You could start excel in safe mode:
> excel /safe
>
> You can search excel's help for: Customize how Excel starts
>
> or
> Description of the startup switches for Excel
> http://support.microsoft.com/kb/291288
>
> Domenick wrote:
> >
> > Anyone know how to launch excel from a command line with a /switch that will
> > cause excel to NOT launce personal.xls?
>
> --
>
> Dave Peterson
> .
>
From: Dave Peterson on 21 May 2010 14:26
Did you try Peter's suggestion?

Domenick wrote:
>
> Well, starting in safe mode DOES keep personal.xls from loading.
> Unfortunately, starting in safe mode does not allow my workbook_open event to
> run either. I all kinds of macro security errors. I guess running in safe
> mode disables all of the "trusted locations" in the trust center? Any other
> ideas?
>
> "Dave Peterson" wrote:
>
> > You could start excel in safe mode:
> > excel /safe
> >
> > You can search excel's help for: Customize how Excel starts
> >
> > or
> > Description of the startup switches for Excel
> > http://support.microsoft.com/kb/291288
> >
> > Domenick wrote:
> > >
> > > Anyone know how to launch excel from a command line with a /switch that will
> > > cause excel to NOT launce personal.xls?
> >
> > --
> >
> > Dave Peterson
> > .
> >

--

Dave Peterson
 |  Next  |  Last
Pages: 1 2
Prev: Running formulas with data from mulitple workbooks
Next: SaveAs *.txt - Outputting with Text quantifiers