I thought that I had posted this earlier this afternoon, but I cannot find it here (should I post this type of question in another section? I don't know). Anyway, I have just changed to Windows 7 (64 bit) yesterday and code that I have used in other OS (XP, Vista, NT) there has been no problems. But with W7 it is having some issues insomuch as it is halting and asking for variables to be declared, where previously this never arose (Office 2003 is what I am running). After trying me shallow arsenal of work arounds I am now thinking that it may be a change in system environment / variables. Or maybe it has something to do with 64 bit. Just the same, I was wondering if anybody has had this experience yet and what was their resolution to it.
I finally got round to customising Excel 2003 as I don't print the spreadsheets very often and I have hit a problem. In Windows 7 the measurement system is set for. CONS: Conversions are relatively slow due to processing within the Excel object. Ex: 1,000.xls files of 100KB each were converted to.xlsx in 13 minutes. Ex: 1,000.xls files of 100KB each were converted to.xlsx in 13 minutes. Download Microsoft Excel for Windows 7. Free and safe download. Download the latest version of the top software, games, programs and apps in 2018.
Thanks for your time. Well I have been working on this for a few hours now and the code it is stumbling over is calling for calendar properties (library, dll?). Worked my way from there. And imported mscomct2.ocx to SysWOW64 and registered it via command line successfully, but alas that did not help. It appears that the equivalent of mscomct2.ocx needed to run calendar for Windows7 ain't there or it is something new and wonderfull that does not add any value to existing code!!
I remember copying mscomct2.ocx to Vista a few years back and everything worked well, but I have exhausted search engines around the globe with this and expect to get a bill next month from Mr & Mrs Google for above and beyond normal use. So if the above throws some light to assist in your efforts I would be happy to see what result you may come up with. Thanks for your time so far.
R's, GordonMS.
Hi, I read a lot of thread about this topic, and I begin to despair:) With this config: Excel 2010 / Windows 7 I found the solution to open 2 Workbooks in separate windows, but from explorer / desktop ONLY! But from Excel (when a document is already opened), if I have an hyperlink in a spreadsheet that points on an other wordbook, when I click on the link, I would like to open it in a new instance of Excel. Same about FILE => OPEN (I would like to open it in a new instance of Excel too, always in fact) Thank you. Hi, To launch multiple instances of Excel, we change it by not using DDE to open the file. Check the 'Ignore other applications that use Dynamic Data Exchange (DDE)' box in Excel -> Excel Options -> Advanced If this does not work,for Windows Vista and Windows 7, we need to edit the registry to remove DDE completely. =============== Important This section, method, or task contains steps that tell you how to modify the registry.
However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. 1. Click Start, in the Search box, type regedit and press Enter.
2. Locate the registry subkey: HKEY_CLASSES_ROOT Excel.Sheet.14 shell Open 3. Delete the ddeexec subkey. 4. Click on the command subkey, and then double-click the Default value from the right pane. Replace the value data with: 'C: Program Files Microsoft Office OFFICE14 EXCEL.EXE' '%1' Double-click the Command string value, replace its data with: (f'^Vn-}f(ZXfeAR6.jiEXCELFiles>!De@]Vz(r=f`1lfq`?R& '%1' Best Regards, Sally Tang.
Hi Pignon007, Now I understood yor question. The answer is that the behavior is by design (or it's a bug in Excel). The point is that both Excel and Word are part of Office, but Word behaves in a diferent way.
To check try doing the same with Word and you will see more than one instance of word will be oppened when you oppen more than one Word doc. Another way to check the different behavior between oppening mutiple Word and Excel files can be checked with Task Manager, in the process tab, it will show many process for Word, but only one process for Excel, both when you oppen mutiple files. Hi, To launch multiple instances of Excel, we change it by not using DDE to open the file. Check the 'Ignore other applications that use Dynamic Data Exchange (DDE)' box in Excel -> Excel Options -> Advanced If this does not work,for Windows Vista and Windows 7, we need to edit the registry to remove DDE completely.