Open a file window (2000 sp3)

Topic

New Reply

Is there a way to create a shortcut to start Excel so the “open” window is already opened and is the active window? I know it just saves one click but it would make the boss happy. Greg

Reply | Quote

Replies

You should be able to search in windows explorer for the file “Excel.exe”
Right click and drag the file to where you want the shortcut and then choose
“Create shortcut” from the popup menu.

You might check your current short cut:
Right-click and choose properties
in Shortcut tab
check what “RUN” is set at. Choose “maximized” or “normal window”
If it is “minimized” it will not be visible.

Steve

Reply | Quote

Thanks Steve, I knew I’d have trouble describing what I was after, this might clarify things. I have a working excel shortcut, it starts excel just fine, to actually start working on a spreadsheet the next step would be to click on the “open” icon (or file, open) this brings up the window I’d like to have a shortcut to so when I double-clicked on it excel would start with the “open” window already opened so he’s ready to browse to the file he wants to open. I’ve attached a picture of the open window I’m referring to. Greg

Reply | Quote

You could open a brand new file
Goto VB and add this code to the workbook object

Private Sub Workbook_Open()
    Application.GetOpenFilename ("Microsoft Excel files,*.xls")
End Sub

The save As
Choose template
and put it in the c: drive under the “XLStart” folder in the Office folder with the name “BOOK”

You will get a macro warning whenever you create a new workbook and it will prompt you for the file to open. If you want a newone just click cancel

Steve

Reply | Quote

You could open a brand new file
Goto VB and add this code to the workbook object

Private Sub Workbook_Open()
    Application.GetOpenFilename ("Microsoft Excel files,*.xls")
End Sub

The save As
Choose template
and put it in the c: drive under the “XLStart” folder in the Office folder with the name “BOOK”

You will get a macro warning whenever you create a new workbook and it will prompt you for the file to open. If you want a newone just click cancel

Steve

Reply | Quote

Thanks Steve, I knew I’d have trouble describing what I was after, this might clarify things. I have a working excel shortcut, it starts excel just fine, to actually start working on a spreadsheet the next step would be to click on the “open” icon (or file, open) this brings up the window I’d like to have a shortcut to so when I double-clicked on it excel would start with the “open” window already opened so he’s ready to browse to the file he wants to open. I’ve attached a picture of the open window I’m referring to. Greg

Reply | Quote

You should be able to search in windows explorer for the file “Excel.exe”
Right click and drag the file to where you want the shortcut and then choose
“Create shortcut” from the popup menu.

You might check your current short cut:
Right-click and choose properties
in Shortcut tab
check what “RUN” is set at. Choose “maximized” or “normal window”
If it is “minimized” it will not be visible.

Steve

Reply | Quote