Disable splash screen in XL04?

J

Jack Marr

Is there a way to disable display of the splash screen in Excel 2004
(or 2008 for that matter) when starting Excel via Applescript? This
would be similar to the Excel/Windows "/embedded" command line switch
- and for the same general purpose, to embed Excel functionality
within another application and make the integration appear somewhat
seamless. "set the startup dialog to false" doesn't do it - that's
for the Project Gallery.
 
B

Bob Greenblatt

Is there a way to disable display of the splash screen in Excel 2004
(or 2008 for that matter) when starting Excel via Applescript? This
would be similar to the Excel/Windows "/embedded" command line switch
- and for the same general purpose, to embed Excel functionality
within another application and make the integration appear somewhat
seamless. "set the startup dialog to false" doesn't do it - that's
for the Project Gallery.
I don't think this is possible via VBA, so I doubt it can be done with
applescript.
 
J

Jim Gordon MVP

Jack said:
Is there a way to disable display of the splash screen in Excel 2004
(or 2008 for that matter) when starting Excel via Applescript? This
would be similar to the Excel/Windows "/embedded" command line switch
- and for the same general purpose, to embed Excel functionality
within another application and make the integration appear somewhat
seamless. "set the startup dialog to false" doesn't do it - that's
for the Project Gallery.

Hi

A similar question was asked in a different newsgroup. The short answer
is that it doesn't seem possible to completely prevent Excel from
showing for a second or so, but the suggestion was made to immediately
move the Excel window off the edge of the display so that any further
activity doesn't show. There's a code example from Peter at this (very
long) URL:
http://groups.google.com/group/micr...c/996a2e08d905b0a8?lnk=st&q=#996a2e08d905b0a8

-Jim

--
Jim Gordon
Mac MVP

MVPs are independent experts who are not affiliated with Microsoft.


Visit my blog
http://blog.360.yahoo.com/blog-i7JMeio7cqvhotIUwCzaJWq9
 
J

Jim Gordon MVP

Jim said:
Hi

A similar question was asked in a different newsgroup. The short answer
is that it doesn't seem possible to completely prevent Excel from
showing for a second or so, but the suggestion was made to immediately
move the Excel window off the edge of the display so that any further
activity doesn't show. There's a code example from Peter at this (very
long) URL:
http://groups.google.com/group/micr...c/996a2e08d905b0a8?lnk=st&q=#996a2e08d905b0a8


-Jim

To follow up a bit more, I found a Microsoft Developer Network article
that talks about how things get started in Excel (and other applications).

This article explains what happens when an application starts up:
http://msdn.microsoft.com/en-us/library/ms233841.aspx

It also explains how to replace and and control how long the splash
screen stays on.

The trouble is that all this fancy stuff requires Visual Studio, which
is not supported on the Mac. I imagine that the folks at MacBU can
manually control all of these things, but these aspects of the
application object are not exposed through the current Mac visual basic
object model.

If you think this sort of stuff should be supported on the Mac, be sure
to send that thought to Microsoft via Excel's Help > Send Feedback feature.

-Jim

--
Jim Gordon
Mac MVP

MVPs are independent experts who are not affiliated with Microsoft.


Visit my blog
http://blog.360.yahoo.com/blog-i7JMeio7cqvhotIUwCzaJWq9
 
J

Jack Marr

If you think this sort of stuff should be supported on the Mac, be sure
to send that thought to Microsoft via Excel's Help > Send Feedback feature..

Thanks, I've now done that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top