'- CHECK NUMBER OF FILES TO CHANGE (VISIBLE ROWS) Set id3 = CreateObject("CDDBControlRoxio.CddbID3Tag") '- worksheet has full path & file name in column OĪpplication.Calculation = xlCalculationManual '- also uses Public variables in READ macro moduleĭim FilesToChange As Integer ' number of files to changeĭim FilesChanged As Integer ' number of files changedĭim MyFilePathName As String ' full path & file name Delete rows for files not changed to save time (can be left). Run macro "READ_FROM_EXPLORER" (other module) TO GET FILE NAMES INTO CURRENTLY ACTIVE WORKSHEET '- Method (works on all files in a single folder) '- Brian Baulsom May 2008 - using Excel 2000/Windows XP '- Suggest you copy some files to a special folder for testing first. '- (was unable to get CDDBControl.dll version 1.2.0.51 to change more than 1 file without crashing) '- this version uses CDDBControlRoxio.dll WMA files do not have track number column 4 '- Reads from amended worksheet prepared with separate "READ_FROM_EXPLORER" macro module. '- MACRO TO CHANGE EXTENDED FILE PROPERTIES OF. I have put the READ macro in the next message. dll needs to be registered on your computer by running regsvr32 followed by its file name. dll there seem to be several around with similar names that could be tried. In "fuzzy" searching for a replacement I found CDDBControlRoxio.dll on my own computer ( I own some of their software) which seems to function the same - except that it actually works. There is a later version 2.0.0.6 but I could not find a download. I originally tried to use CDDBControl.dll version 1.2.0.51 which is widely available on the internet but found that I could only get it to change 1 file before crashing Excel. Here is a new version of the Write macro that works as normal. The Read macro puts file data into a worksheet for making changes, the Write macro uses the worksheet to change the files.The problem with the Write macro was that, although it did work, it used SendKeys which has to be slowed down considerably. About a year ago I posted a pair of macros to read/write MP3 tags.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |