I did not apprecate that you were reading Excel files at the byte level,
something that no Excel methods support (Get being
VB). I had Excel methods
in mind in saying that we can assume MS has made whatever changes are
necessary for them to continue to work in Excel 2007 despite the file format
change.
The plot thickens in the new version because besides the XML in ZIP files
that are XLSX and XLSM files there is the new binary in ZIP format XLSB and,
of course, the old binary format is still supported.
Reading Excel files directly is something very few people have done or need
to do but your task may be easier because the new formats are 'open' and so
publically documented. I would think your first step would be to unzip the
new files...
--
Jim
"TC" wrote in message
...
Hey Jim,
OK. Let's assume we're using Excel 2003 for starters and we have the
following code:
Dim abytFile(1) As Byte
Get m_hFile, , abytFile
If I use the above code with an Excel created in XL 2003 and earlier, the
BOF markers are 9 for lower and 8 for upper byte and the EOF markers are
10 for lower byte and 0 for upper byte. If run against an .xlsx file, it
fails.
Thus, the question is, if there is VBA code that loops through records in
a workbook via Get / Seek, what are the distinguishing markers for these
later workbooks?
Thanks
"Jim Rech" wrote in message
...
For the most part I'd say the file format change should be transparent to
users and not something to worry about. It seems that you've assumed
that some macros that worked in earlier Excels will be broken in 2007.
Some have been but for the most part MS has tried and succeeded in not
making that so. It may not always seem that way but they want people to
upgrade and try not to create reasons for them not to. So I think the
presumption should be that things will work unless shown otherwise.
--
Jim
"TC" wrote in message
...
Hey All,
Since the new Excel file formats are different, I was wondering how
folks are dealing with legacy VBA code that uses Get and Seek functions
to work with things. I ask because I'm soon going to be facing these
questions ;-)
Any advice / recommendations would be greatly appreciated.
Thanks!