metadata

Hi, I was spurred to explore this subject further after this recent thread As far as I can see, there seems to be no easy way to edit file properties programmatically without needing to resort to external components such as CDDBControl.dll or CDDBControlRoxio.dll (which by the way these two...

Hi! So I got my whole Music Library in a Folder (+5000 Songs) and I wanted to rearrange the tags of the mp3 files and the file name. So I got to this code to Read the properties of every mp3 file in a folder: " Sub Read_MP3_Files() Dim FolderPath As Variant Dim Item As Object Dim oFile As...

I have a VBA macro that i want to run. It is supposed to pull MP3 + Wav meta data into excel. When I run it, it seems to work but doesnt actually pull in any data. Can anyone suggest what might be wrong? I am very inexperienced with VBA. Thanks, WC

Is there a way to create a list of files in a folder including subfolders and then display the title/description and Author? I have to update the metadata in lots of pdf files and it's taking forever to do this manually. I know there are ways to use VBA to get a list of files from a...

Our company has > 65,000 workbooks on our shared file server. I'm working on an Excel VBA routine that documents ODBC and Workbook Connections, external Excel Links, Power Queries, etc., for each workbook and write it all out to a text file. It actually works pretty darned well... except when it...

I have posted a couple of times needing help, no luck. So I tried to do it myself, and have been.....unsuccessful. Admittedly I am not very proficient and VBA. Wondering if anyone could take a look at what I got. Help me make the adjustments. Thanks in advance for any help! Need to have...

I have an excel template that I keep in sharepoint. When I get a new client, I use the template to create a new file. I was really hoping to link a few cells in the file to the metadata in sharepoint either upon cell value change or saving the document. I linked them through custom...

I am looking to populate excel file metadata in SharePoint 365 from specific cells within the excel file. I am able to create the linked Advanced Properties within the file, import it into SharePoint, and auto populate the values on the initial load. The problem is, when users update the...

Hi all, Is it possible to get all meta data of mp3 and wav files into excel of a specific folder? I need the data: filename, artists, song title, bpm, genre, album and key of the song. Thank you in advance.

sharepoint 2013 and excel 2010 if i go to File -> Info -> Properties -> Show Document Panels i have metadata of Title: PostGrad: if i key in ttt to PostGrad metadata and save and close Excel, back on sharepoint page i see ttt in PostGrad column. so i know the...

Guys I would like your support on how to retrieve all TAG metadata from files that are saved on some folder including its subfolders. The idea is list all Tag Metadata as unique values in a txt file. Unique because it can be repeatable due the loop will check on different files. Below an example...

Hello all, So, I'm trying to gather several properties for a number of workbooks in a folder: Original Author Creation Date File Size File Type i have been using the .BuiltinDocumentProperties property to gather the author and creation date but I'm having difficulty getting the last two...

I'm copying out a range of data from a report formatted as an .xlsx into my running report. Along with the data, I want to capture the file "Creation Date" metadata to use as the worksheet name. It's also going into the first blank cell in a column range so using that cell for the worksheet...

I can find multiple post on how to hide it, even how to display it on screen. I have found some VBA showing how to print a list of the properties and VBA to print propteries to the Immediate window. All of these are "almost" what I need. I need to be able to "print the properites" to a new...

<tbody> 282.97 156.34 285.12 126.57 234.14 285.89 157.97 285.71 126.65 234.17 </tbody> Row 1 above would count 4 - Column 1 matches column 3 within 10 and Column 4 matches 5 Each column represents Degrees 0 to 360 (around 40,000 records) It is a quality assurance metadata for a...

I have a macro that creates a hyperlink for every file in a pre-designated folder. However, I was wondering if I can also add in the metadata "Date Picture Taken" and "Size" on columns B and C (it doesn't have to be in that order)? I want to use the metadata to know when a certain photo was...

Is there a way to find out the date and time an excel file has been opened within the file?

I have a lot of .xlsx (or .xlsm) stored on SharePoint sites. We store several pieces of data in the metadata area of the files. I would like to either use a UDF or some kind of method to display some of the metadata in my spreadsheet. I would prefer NOT to have to open the properties window...

Greetings, I would like help creating a document to harvest information (metadata) from digital images (jpegs and others) from within specific folders. Specifically, I want columns with Filename - Keywords - Title - Date Modified - Description. I appreciate any help you can provide. I am using...

In windows system32 and some in windows pro Photo Tools there are some dll about images ima......dll and photos When I try to reference them from VBA Excel the dreaded Can't reference error turns up.. Can this be fixed...... if not are there any good dll available... free... for metadata and...