You are right, I found it's my fault because "Sheet1" was not my active worksheet. Your simple code is great for data content cleaning. I learned one ...
Function ListMyFiles() works smoothly now taking the auguments specifed on cell A1 & B2 instead of hard code. While ClearData() got a little probl...
I use the following script as a workaround to clear the dynamic range and it's workable: Sub ClearData() Range("A3:H3").Select Range(Selection,...
Hi Catalin, After a whole night trial and error yesterday finally the main issue "retrieving the author" seemed to be solved right now. However ple...
Have you tested the file? it got stucked on the line Cells(iRow, iCol).Value = DirObject.GetDetailsOf(DirObject.ParseName(MyFile.Name), 20) 'auth...
Sorry, still got problems. I'm really frustrated after several days strugle. Could you please send me a complete file?
Catalin, After running your script it's true the parameter is also "20" for the file author on my Excel 2013. However, could you please do me one m...
I got the error message "test.xlsm: Error 104 - You do not have permission to upload files". Do I need to apply some authorization any more. For your ...
Sorry for that, I thought it should be under the topic of VAB & Macros. Besides, I tried your answered script but still failed to get the solution...
Hi Catalin, I amended my script accordingly but still got no author information, and the file list populates starting row 2 instead of row 3, I don...
Hi Derek , I got the following VBA script the other day, but still had no way to retrieve the file author with the line I highlighted in bold font ...
I've used Power Query to get a long list of Excel files and I wanted to add a custom column populating the related author for each row. Function Autho...
Hi Sunny, Just came out two more findings for your reference: Both simplified Chinese characters and m4a file extensions could not be recognized wh...