Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dsofile.dll and Excel 2007 file format
Hi,
i intend to read document properties (meta info) of an Excel file with dsofile.dll. I read that it works fine with Excel 2003 file format. Does ist also work with Excel 2007 file format? TIA Reinhard |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
dsofile.dll and Excel 2007 file format
Yes, it works fine with Office 2007 files.
Regards, Peter T "Reinhard Thomann" wrote in message ... Hi, i intend to read document properties (meta info) of an Excel file with dsofile.dll. I read that it works fine with Excel 2003 file format. Does ist also work with Excel 2007 file format? TIA Reinhard |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
dsofile.dll and Excel 2007 file format
Thanks.
It works fine with dsofile.dll 2.1 as long as file extension is *.xlsx If i change file extension to something else e.g. *.aaaa it fails. Excel file format 97-2003 doesn't habe this restriction! How can i overcome this behavior, because i don't like to change the file extension of my application? TIA Reinhard "Peter T" <peter_t@discussions schrieb im Newsbeitrag ... Yes, it works fine with Office 2007 files. Regards, Peter T "Reinhard Thomann" wrote in message ... Hi, i intend to read document properties (meta info) of an Excel file with dsofile.dll. I read that it works fine with Excel 2003 file format. Does ist also work with Excel 2007 file format? TIA Reinhard |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
dsofile.dll and Excel 2007 file format
If i change file extension to something else e.g. *.aaaa it fails.
It doesn't "fail" but you can't see all the Office doc' properties. Simply rename the file before you start and rename as original when done Sub test() Dim sFile As String, sFileTmp As String Dim dso As DSOFile.OleDocumentProperties ' first ensure the file is not already open sFile = "C:\<path\myExcel2007file.aaaa" sFileTmp = sFile & ".xlsx" Name sFile As sFileTmp Set dso = New DSOFile.OleDocumentProperties dso.Open sFileTmp ' do stuff dso.Close Name sFileTmp As sFile End Sub Regards, Peter T "Reinhard Thomann" wrote in message ... Thanks. It works fine with dsofile.dll 2.1 as long as file extension is *.xlsx If i change file extension to something else e.g. *.aaaa it fails. Excel file format 97-2003 doesn't habe this restriction! How can i overcome this behavior, because i don't like to change the file extension of my application? TIA Reinhard "Peter T" <peter_t@discussions schrieb im Newsbeitrag ... Yes, it works fine with Office 2007 files. Regards, Peter T "Reinhard Thomann" wrote in message ... Hi, i intend to read document properties (meta info) of an Excel file with dsofile.dll. I read that it works fine with Excel 2003 file format. Does ist also work with Excel 2007 file format? TIA Reinhard |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
dsofile.dll and Excel 2007 file format
Hi Peter,
that's it. Many thanks for your help. Regards Reinhard "Peter T" <peter_t@discussions schrieb im Newsbeitrag ... If i change file extension to something else e.g. *.aaaa it fails. It doesn't "fail" but you can't see all the Office doc' properties. Simply rename the file before you start and rename as original when done Sub test() Dim sFile As String, sFileTmp As String Dim dso As DSOFile.OleDocumentProperties ' first ensure the file is not already open sFile = "C:\<path\myExcel2007file.aaaa" sFileTmp = sFile & ".xlsx" Name sFile As sFileTmp Set dso = New DSOFile.OleDocumentProperties dso.Open sFileTmp ' do stuff dso.Close Name sFileTmp As sFile End Sub Regards, Peter T "Reinhard Thomann" wrote in message ... Thanks. It works fine with dsofile.dll 2.1 as long as file extension is *.xlsx If i change file extension to something else e.g. *.aaaa it fails. Excel file format 97-2003 doesn't habe this restriction! How can i overcome this behavior, because i don't like to change the file extension of my application? TIA Reinhard "Peter T" <peter_t@discussions schrieb im Newsbeitrag ... Yes, it works fine with Office 2007 files. Regards, Peter T "Reinhard Thomann" wrote in message ... Hi, i intend to read document properties (meta info) of an Excel file with dsofile.dll. I read that it works fine with Excel 2003 file format. Does ist also work with Excel 2007 file format? TIA Reinhard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I import a file in DTF format into Excel 2007? | Excel Discussion (Misc queries) | |||
HOW DO I CONVERT EXCEL FILE TO DBF FORMAT IN OFFICE 2007 ? | Excel Programming | |||
Format of CSV file not preserved when edited in Excel 2007 | Excel Worksheet Functions | |||
Openig CSV file format with Excel in Office 2007 | Setting up and Configuration of Excel | |||
Excel 2007 XML file format | Excel Programming |