Posted to microsoft.public.excel.programming
|
|
Question about opening workbooks on Excel startup
ps. I didn't test this either.
Andy wrote:
I haven't tested this idea, but it sounds good.
In the Testbook, add a macro to "Thisworkbook" for the
open event. (Can't remember the exact wording, something
like Private Sub Open_Workbook or something--someone
help here...) Anyway, the command "Workbooks.Add" will
open a new workbook as you desire.
Andy
-----Original Message-----
This only works partially. When I open Excel it opens
TextBook as hidden
but it does NOT open a new blank workbook, e.g. Book1.xls
Any other suggestions?
-gk-
"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in
message
...
Open TestBook and hide it using Window | Hide. Be sure
to save it when
prompted.
--
Vasant
"38N90W" wrote in message
...
Windows XP Pro
Excel 2002
I would like to open particular workbook every time
Excel starts,
similar
to
how PERSONAL.XLS opens when I start Excel. As a
test I saved a workbook
in
the same folder as the PERSONAL.XLS file, and sure
enough it opened also
with Excel. However, I would like this workbook,
call it TestBook, to
open
up hidden like PERSONAL.XLS does, and I'd still like
Excel to open a new
workbook Book1.xls every time Excel starts. Is this
possible? If so,
how?
Thanks!
-gk-
--
================================================== ========
==============
"The creative act is not the province of remote
oracles or rarefied
geniuses but a transparent process that is open to
everyone."
-Greg Kot in Wilco Learning How To Die-
.
--
Dave Peterson
|