Vba find...

[ISY]

I'm trying to get the following information:
Vba to list the properties File of the Excel file type contained: Sheets1, Sheets2 ... ecc

 

[John_w]

I'm not quite sure what you're asking for. Do you want to list in an Excel sheet the file properties, for example size, date created, of all Excel files (*.xls) in a specific folder? If so, what is the specific folder and which file properties?

Otherwise if I'm wrong, please explain exactly what you want.

 

[ISY]

Hallo

I hope to further clarify the request, I would peter list the cards as an excel file without opening the image file, but reading the data in a disk type: explorer

following image




Of course these properties can be read without problems if the file is open
Thanks for the suggestions

 

[John_w]

I now understand what you're asking for - read the properties (File - Properties - Contents tab) of an Excel workbook.

http://www.cpearson.com/excel/docprop.aspx might help.

 

[Andrew Poulsom]

You can use ADO to get the names of the worksheets:

http://www.mrexcel.com/forum/showthread.php?t=47074

 

[ISY]

Hallo

Thank you for answer, I think there is only this possibility.
I saw the code, but on my Windows XP SP2 PC is missing some references to test:
----------------------------------------------------
'****'Needs a reference to:
'****'Microsoft ActiveX Data Object X.X Library
'****'Microsoft ADO Ext. X.X for DLL and Security
'****
Dim objConn As ADODB.Connection
----------------------------------------------------
How can I fix?

 

[Andrew Poulsom]

In the Visual Basic Editor choose Tools|References. Find them in the list and check them.

 

[ISY]

Hallo




I loaded a bit and now works will remove unnecessary ones.
Thank you so much hours will finish the tests