Excel - On open, do this...

[SWarrior]

Thanks to a co-worker who never documented anything...
I'm stuck with trying to figure out his "cutsie" tweaks to
things that people want. What I need to know is how in
god's name I can get Excel to automaticly start the "Open
Document" when Excel is started. Basically it's a savings
of one click .. <sigh> Lazy... But the customer alway's
get's what they want.... I suppose the'll want excel to
ask them "One lump or Two, and would you like cream with
than ma'am?"

Many Thanks in advance for your help!!!

 

[Gord Dibben]

SWarrior

Not sure what you want. "Open Document" means show File>Open dialog box?

"Open Document" means open a particular file?

For first you need VBA.

Private Sub WorkBook_Open()
Dim fd As FileDialog
Set fd = Application.FileDialog(msoFileDialogFilePicker)
fd.show
End Sub

Placed in the ThisWorkBook module of your Personal.xls file. If you don't
have one of these or do not understand VBA and Macros post back or see David
McRitchie's "Getting Started" at.....

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Second you simply find the File in Windows Explorer and right-click "create a
shortcut on desktop".

Gord Dibben Excel MVP