Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Maybe this page Will help
Folder Index VBA
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I would like to create an index for all the files in a google drive folder on my Mac, using excel 2011. Preferably where one can insert the folder directory to index in a sheet, press "run", and then get all the files and folders there get listed in a new sheet.
I have tried a few scripts online but couldn't get them to work. There seems to be a problem with the DIR function using excel 2011 on Mac.
Does anyone know how to do this?
Thanks for the help!
André
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Anonymous