Skip to main content

Hi all,

I have recently started using Bynder and have been working with our business teams to migrate older assets. To streamline this process and avoid the need for navigating through file explorer and all the subfolders, or asking for help running PowerShell. I developed an Excel based tool that offers the following functionalities:

  • Automatically scans all designated subfolders and extracts file names along with their folder paths.
  • Identifies and highlights duplicate file names.
  • Enables users to manually select and move desired files to a mass uploader tab.
  • Facilitates the addition of appropriate metadata to assets through dynamic dropdown boxes.
  • Generates a .csv file for upload at the push of a button.

It’s a little slow when it has to scroll through a lot of subfolders, but a lot faster than doing it manually!

While this solution is not perfect, it has proven to be helpful for our business units so far. Please note that this tool relies on VBA and must be opened in the Excel application, as it is not compatible with browser or MS Teams environments.
Note, we use Windows and are on Microsoft 365, there may be compatibility issues with other versions of Excel. 

Amazing, thanks for sharing! Excited to dig into this further.


Welcome to the Community ​@Brent Albrecht! Thank you for taking the time to share this. I agree with Brian, this is amazing!


@Brent Albrecht hi Brent. Great idea, thanks for sharing. My company is blocking the file due to the macros. Any chance you can share another version? Sorry if this is a weird question - excel newbie here 😃


Woah, Amazing, thanks for sharing!


Hi ​@Katie_ARTDECO,

Sorry I missed this.

I have attached a new version that is just .xslx so doesn’t have any VBA code that’s able to be run. Instead, I copied the code to a new tab called ‘VBA’.

You might find that you can open it as excel and then copy the code from cell I23 to cell I221 into the VBA editor.

To do this you need to push alt+F11 this will open the VBA editor, then on the menu select ‘Insert’ and ‘Module’ that should open a blank window for you to copy for above range into (cells I23 to I221).

Then you will need to go back to the ‘Main’ tab right click on the buttons and and select ‘Assign Macro’ you should be able to select the ones mentioned at the top of the ‘VBA tab’.

Everything should now work…. You will need to save it as a .xslm file though otherwise it will not retain the macros.

There always appear to be a difference in ‘creating your own’ macro enabled spreadsheets vs downloading one.

 

Hopefully this helps 


Reply