[comp.windows.ms] Stop Sheet1 in Excel, suggestion for Program Manager

rspangle@jarthur.Claremont.EDU (Froot Loop) (10/11/90)

Well, I finally got tired of Sheet1 popping up every time I started Excel
without a worksheet filename.

So this afternoon I sat down and worked out a little macro that basically
loads in and hides itself.  I wanted to make it close itself instead, but
I couldn't seem to make it do that.  So I settled for having a little (~1K)
hidden macro sheet instead.

Since the file is so small, I have included a uuencode of it at the end of 
this post.  To use it, uudecode it and put it in your Excel directory.
Then click once on the Excel icon in Program Manager and select 
Properties... from the file menu.  Append  NOSHEET1.XLM to the end of the
command line.

So for my setup I changed
C:\EXCEL\EXCEL.EXE
to
C:\EXCEL\EXCEL.EXE NOSHEET1.XLM

And then select OK.  The next time you double-click on EXCEL, it will come
up without Sheet1 cluttering things up.

(and now the suggestion about Program Manager)

It would be really nice if you could drag a file from File Manager onto
an application icon in Program Manager, and then have that application
start up using the file you dragged in.  You can drag files onto applications
in File Manager, but then you need to have the directory that your
application is in open also.

(random note about the annoying DOS icon for minimized standard apps)

The DOS icon appears to be located in three separate files (not counting
progman.exe):

winoa286.mod
winoa386.mod
winoldap.mod

I'm not sure if it would be possible to have several different copies of
these files around or not - if so, you could write a little batch program
which renames telix.mod (the modified version of winoa386.mod that you've
made which has a new icon in it) to winoa386.mod, and then runs Telix.

Anyone who knows more about icons and other such resources care to comment?

-- 
 --------------------------------------------------------------------------
|    Randy Spangler                    |    The less things change, the    |
|    rspangle@jarthur.claremont.edu    |    more they remain the same      |
 --------------------------------------------------------------------------

jls@hsv3.UUCP (James Seidman) (10/11/90)

In article <8998@jarthur.Claremont.EDU> rspangle@jarthur.Claremont.EDU (Froot Loop) writes:
>The DOS icon appears to be located in three separate files (not counting
>progman.exe):
>
>winoa286.mod
>winoa386.mod
>winoldap.mod
>
>I'm not sure if it would be possible to have several different copies of
>these files around or not - if so, you could write a little batch program
>which renames telix.mod (the modified version of winoa386.mod that you've
>made which has a new icon in it) to winoa386.mod, and then runs Telix.
>
>Anyone who knows more about icons and other such resources care to comment?

I don't think that this plan will work.  Bringing up several windowed
sessions and running HEAPWALK (which is a program which comes with the
SDK to look at the global memory heap), I see only one copy of the icon
resource.  This is exactly what I expect, since any (well-written)
Windows program checks to see if there is a previous instance of itself
already in memory, and if so uses its resources instead of loading its
own.  Since resources are (in theory if not in practice) read-only, this
saves on memory.

The only real solution would be much more complicated:  write an application
which installs a Windows hook to intercept messages.  Then you can find out
when a DOS window is being minimized, and paint your own icon over the one
that winoldap drew.  Let me know when you get it all worked out, Randy.
It's as easy as LPC. :)

-- 
Jim Seidman (Drax), the accidental engineer.
"There's a certain freedom to being completely screwed." - The Freshman
UUCP: ames!vsi1!headland!jls
ARPA: headland.UUCP!jls@apple.com