1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Multiple Excel 2003 windows in Windows 2007

Discussion in 'Business Applications' started by mommyoftwo78, Dec 20, 2011.

Thread Status:
Not open for further replies.
  1. mommyoftwo78

    mommyoftwo78 Thread Starter

    Joined:
    Dec 20, 2011
    Messages:
    1
    I need to be able to have Excel open new files in a new window, instead of the one already open. I've tried searching the web for ideas, but cannot seem to find anyone with a solution to Windows 7 with Excel 2003. Please help!!
     
  2. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    Hi, welcome to the forum.
    I sugest you search the forum for similar questions. Spacefamily had the same question.

    I offered a vbs script to do it:

    Code:
    Public GetAbsolutePath, GetTheParent
    Dim objExcel, f, objFso, fname
    Set objFso = CreateObject("Scripting.FileSystemObject") 
    Set objExcel = CreateObject("Excel.Application")
    GetAbsolutePath = objfso.GetAbsolutePathName(Wscript.ScriptName)
    GetTheParent = Objfso.GetParentFolderName(WScript.ScriptFullName) 'Returns the parentfolder of the Path/File specified
    
    fname = Array("<filename here incl extension>","<filename here incl extension>")
    For f = LBound(fname) To UBound(fname)
    	If objFso.FileExists(GetTheParent & "\" & fname(f)) Then
    		MsgBox fname(f),,f
    		objExcel.Workbooks.Open(GetTheParent & "\" &fname(f))
    		objExcel.Visible = True
    	End If
    Next 
    Set objExcel=Nothing
    Set objFso=Nothing 
    WScript.quit
    
    
    Save the code as <anyname>.vbs and place it in the folder that holds the excel files.
    Doubleclick to run.
    If will show a message box and open that file etc etc all in a new Excel session.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1032128

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice