Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 3rd 09, 09:25 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 32
Default Open Excel 2007 files in new instances

I would like to open each workbook in a new instance when opening from
explorer. In XP I changed the file context menu Open command to include the
"%1" parameter, and this worked well.
Now I have Windows7 I'm having problems. I have again added the parameter,
and disabled the DDE message [open("%1")] (as I did in XP) and now excel
opens blank, (there was already an /e switch which I gather tells Excel to
not open a blank worksheet). I have run the command via the command line and
it works without problem, so I assume that the parameter is just not being
sent to Excel through explorer.

Is this a Windows7 problem then, rather than an Excel one? Is there a DDE
message that I can send instead of Open that will tell Excel to open in a new
instance?

Using Excel 2007on Window7 x86.

Many Thanks

  #2   Report Post  
Old December 3rd 09, 10:24 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 32
Default Open Excel 2007 files in new instances

Typical, found the answer in the next search entry I tried!

You need to hack the registry as found here http://brett.batie.com/?p=85 :
Delete the following lines in the registry (or rename):
HKCR\Excel.Sheet.8\shell\Open\ddeexec
HKCR\Excel.Sheet.12\shell\Open\ddeexec
and change the below like shown:
HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\comman d
C:\Program Files\Microsoft Office\Office12\EXCEL.EXE /e “%1″
HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command
C:\Program Files\Microsoft Office\Office12\EXCEL.EXE /e “%1″

Works just like in XP.

Thanks!

"Iain" wrote:

I would like to open each workbook in a new instance when opening from
explorer. In XP I changed the file context menu Open command to include the
"%1" parameter, and this worked well.
Now I have Windows7 I'm having problems. I have again added the parameter,
and disabled the DDE message [open("%1")] (as I did in XP) and now excel
opens blank, (there was already an /e switch which I gather tells Excel to
not open a blank worksheet). I have run the command via the command line and
it works without problem, so I assume that the parameter is just not being
sent to Excel through explorer.

Is this a Windows7 problem then, rather than an Excel one? Is there a DDE
message that I can send instead of Open that will tell Excel to open in a new
instance?

Using Excel 2007on Window7 x86.

Many Thanks



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to open wk1 files in excel 2007 rr76012 Excel Discussion (Misc queries) 2 September 4th 09 12:36 AM
Opening .xlsx files in separate instances of Excel 2007 Tim H Excel Discussion (Misc queries) 0 April 8th 09 11:57 PM
Open two instances of Excel, Excel 2007 Dale Fye Excel Discussion (Misc queries) 3 August 12th 08 07:56 PM
I have Excel 2007. Some of my files open and some do not. Why? Rob Excel Discussion (Misc queries) 0 December 12th 07 03:01 PM
Excel opens new instances when I text-open files Eric Excel Discussion (Misc queries) 0 November 15th 06 05:53 AM


All times are GMT +1. The time now is 05:04 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017