Excel 2007 displays unwanted messages on opening 2003 XLS files

S

Steve Rindsberg

I'm automating Excel to retrieve data from worksheets.

When my code runs in Office 2007 and opens an XLS file in Excel, I get
this:

Do you want to save the changes to [FILENAME]? Microsoft Office Excel
recalculates forumlas when opening files last saved by an earlier
version of Excel

Emphatically not. My code opens the file READ-ONLY for just that
reason:

Set oXLWB = oXLApp.Workbooks.Open(sFilename, , True)

Haven't had a chance to see if SP2 corrects this but that's next on the
agenda.

But does anyone know if this is by design or a bug, and in either case,
is there another parameter to the .Open method that'd make it behave
more reasonably? Sort of a "Which part of READ-ONLY don't you
understand?" option. ;-)

TIA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Opening XLS (2003) workbooks in 2007 (XLSX) 1
Excel 2007 PIA saves as .xlsx with .xls extension 2
Opening xls files in Excel 2007 1
any special trick to opening up corrupt XLS files 3
Opening multiple Excel files from IE browser does not open in new instance of Excel - BUG? 0
set Excel 2007 as default to save files in Excel 2003 .xls format 1
Opening multiple XLS files 6
Excel 2007 recalculates Excel 2003 spreadsheet upon opening 1

Top