Multiple Excel Sessions

[spacefamily]

How do I open multiple excel sessions? Opening multiple windows within one excel session/window is not productive in working/comparing multiple spreadsheets.

 

[Keebellah]

Hi, welcome to the forum.

I tried a batch file but it uses the same Excel session
I tried the vbs script below and it does the job:

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("[COLOR="Red"]<filename here incl extension>[/COLOR]","[COLOR="Red"]<filename here incl extension>[/COLOR]")
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

Copy the code to Notepad and choose save as and type the name in between quotes "<the name you give it>.vbs" so that the .txt extension won't be used.
Place this one in the saem folder as you Execl files.

If the files are in different folders then you will have to include the fullpaath instead of GetTheParent

This will open all the Execl files in a new Excel session

I hope I've been able to explain it a bit.

 

[Noyb]

http://my.opera.com/Jarrah/blog/how-to-make-excel-open-each-file-in-a-separate-window

 

[Keebellah]

Nice one, but then it will do it all the time.

BTW, Office 2010 is Office14 so then you have them all