Force multiple application windows

[ljwmis]

I have seen similar questions for later versions of MS Office but not for MS Office 97.

Windows 2000 running MS Office 97.

How can you force multiple Word/Excel documents to open in a totally new application window each time, rather than in the same window and on top of a currently opened document?

 

[Bowers74]

I can't test to see if this works in '97 because I only have 2000 and XP.

Sub NewWord_NewExcel()
Dim xl As New Excel.Application
Dim wd As Word.Application
Set wd = CreateObject("Word.application")
Set xl = CreateObject("Excel.Application")
With wd
    .Documents.Add
    .Visible = True
End With
With xl
    .Workbooks.Add
    .Visible = True
End With
End Sub

This will create both a new Word document and a new Excel workbook, and they will be open in new application windows (at least in 2000).

I hope this helps!

Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[Zathras]

I assume you mean opening by double-clicking on the file name in an Explorer-type folder display. (If you are using File/Open from within Excel it will always open a file in that instance.)

In Excel 97 go to Tools/Options/General and check the box that says "Ignore other applications" I don't know about Word.

The other thing you can try if the other ways don't work is to look at View/Folder Options/File Types in an Explorer-type folder display. Find the entries for .doc and/or .xls types, work your way down to where you can edit the Open command, and uncheck "Use DDE"

 

[Bowers74]

Hi ljw,

It's been a few days and no word from you if you solved this, but I haven't forgotten you. I was looking through the FAQ's for this forum and found two FAQ's that might interest you.

faq68-1269 for Word

faq68-1371 for Excel


Check out these FAQ's and look for the switch /n in the Word FAQ. It might work for Excel as well.

I hope this helps!





Peace!

Mike

Never say Never!!!
Nothing is impossible!!!