Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Feb 2003
    Location
    Kansas, USA
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Open a file window (2000 sp3)

    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

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Open a file window (2000 sp3)

    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

  3. #3
    Lounger
    Join Date
    Feb 2003
    Location
    Kansas, USA
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Open a file window (2000 sp3)

    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

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Open a file window (2000 sp3)

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

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


    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •