[AccessD] An Excel 2007 Observation

Hi John,

In your tests, try using the Common Dialog or OpenFileName API
to open any version prior to Access 2007. Then use Start ... Run.
That should be an interesting excursion.

The explanation I've read for this is that the ProgID is unchanged
between versions and therefore resolves to 2007.

Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com

----- Original Message ----- 
From: "jwcolby" <jwcolby at colbyconsulting.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Tuesday, November 13, 2007 9:11 AM
Subject: [AccessD] An Excel 2007 Observation


>I installed Office 2007 on a server where I already had Office 2003
> installed.  I use Office 2003 (specifically Excel) on that machine quite a
> bit.  this morning I just double clicked on a spreadsheet and it was 
> loaded
> in Excel 2007 (Office 2007 apparently replaced my file type mappings).  I
> checked the task manager memory usage and it was 20.6 mb for Excel with 
> that
> specific spreadsheet.  I then closed Excel 2007, opened Excel 2003 and 
> then
> loaded the same spreadsheet.  The memory usage was 10.5 mb.
>
> And BTW, there was no noticeable delay switching between the two versions,
> nor did it request a disk etc.  I will do more testing on that subject 
> later
> when the server isn't working heavily on SQL Server stuff.
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com