> 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" <(E-Mail Removed)> wrote in message
news:OK3A%(E-Mail Removed)...
> 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
> news:%(E-Mail Removed)...
>> Yes, it works fine with Office 2007 files.
>>
>> Regards,
>> Peter T
>>
>> "Reinhard Thomann" <(E-Mail Removed)> wrote in message
>> news:%23c%(E-Mail Removed)...
>>> 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
>>
>>
>
Similar Threads
