Extract Excel File Properties Using VBA Without Opening

Talk to you soon.

Prove you're human: Type the code shown.

By clicking any of the above buttons, I agree to the terms & conditions and privacy policy, and I consent to receive updates via SMS or email

+44 (0)20 3769 3689

Power BI Reporting:
Beginner to Expert
Power BI | Power Pivot | Power Query | DAX
Microsoft Excel Reporting:
Business Reporting & Model Building
60+ Formulas | Data Stories | Advanced Reporting & Modeling
Excel VBA Programming
for Automation
VB Programming | Report Automation |
MS-Office Automation

Business Professionals

Techno-Business Professionals

Technology Professionals

Programs & Courses

New

Home

About Us

Programs & Courses

New

Home | About Us | Contact Us

+44 (0)20 3769 3689

support@excelgoodies.uk

ExcelGoodies WorldwideUK | USA | Australia | Singapore | Phillipinnes

How to extract Excel File properties without opening a File using VBA?

There are many cases where we need to get the document property without the file being opened in VBA.

This can be achieved by using the objects available in DSOFile.dll.

To begin with, add a reference to DSO Ole Document’s property library as shown in the below image.

Function GetPropFromDSO(ByVal sFile As String, ByVal sCP As String) As String
Dim oFil As DSOFile.OleDocumentProperties
Dim oCP As DSOFile.CustomProperties
On Error GoTo Err_Tp
Set oFil = New OleDocumentProperties
oFil.Open sFile, True
Set oCP = oFil.CustomProperties
GetRevFromDSO = oCP(sCP)
.Value
oFil.Close
Err_Tp:
If Err ;; 0 Then
Err.Clear
Resume Next
End If
End Function

The function gets the Filename and the Property to be extracted and returns the property value.

Explore comprehensive Course on Excel Automation or VB Programming here and, learn to write VB coding with ease.

Happy Excelling
Team Excelgoodies

VBA & Python

Don't forgot to share this post!

New

Next Batches Now Live

Power BI