Batch processing (xlsx to xlsb) in Excel 2010

Sorry.

My folder topology looks like this:
main folder -> containing 44 folders -> each of them containing 1-3 specific folders -> where each of those specific folders contain 1 specific folder -> which contains the xlsx-files (about 10-30 files) which need to be converted into xlsb-files.

So the 44 subfolders contain around 1800 xlsx files?
Is the "1 specific folder" in the subfolder named the same?
Is that 10-30 files in each "1 specific folder" or all up?
Do the files that need converting have anything in common. eg tag, dates?
Can you do a search in Explorer and return those specfic files or sort returned files so there grouped?

If there's only 10-30 files in one folder that need converting it wil probably be easier just to copy the paths one by one.

Otherwise does the "1 specific folder" named exactly the same exist in multiple subfolders and contain only the files to be converted?

Draw me a better picture, eg.
Main Folder
-Sub1
---FolderW
-----Files (don't convert)
---FolderX
-----Files (don't convert)
---Specific Folder
-----Files (All Convert)

-Sub2
---FolderY
-----Files (don't convert)
---FolderZ
-----Files (don't convert)
---Specific Folder
-----Files (Some Convert)

First try this,

Code:

For /r "C:\Main Folder" %i in ("Specific Folder\*.xlsx") do echo %i >> FilePaths.txt

My mistake again.
Just open the main folder in Explorer and search for "Specific Folder".
Select all folders, hold shift and right click.
Click Copy as Path
Paste into notepad

Edit > Replace
Find: "
Leave Replace blank and Replace all

Edit > Replace
Find: Specific Folder
Replace: Specific Folder\
Replace all

I tested the macro and it won't work if the path contains the quotes.

Edit: Just paste straight into Excel and do the second Replace

I don't think anyone can provide you with a 1-click solution, whatever method you use will require you to put in some manual effort.

Duzzy said:

My mistake again.
Just open the main folder in Explorer and search for "Specific Folder".
Select all folders, hold shift and right click.
Click Copy as Path
Paste into notepad

Edit > Replace
Find: "
Leave Replace blank and Replace all

Edit > Replace
Find: Specific Folder
Replace: Specific Folder\
Replace all

I tested the macro and it won't work if the path contains the quotes.

Edit: Just paste straight into Excel and do the second Replace

The macro could be modified to add the backslash which would eliminate the need for the second Replace. Replace this line:

Code:

strPath = ThisWorkbook.Worksheets(1).Cells(i, 1).Value

with this:

Code:

strPath = ThisWorkbook.Worksheets(1).Cells(i, 1).Value & "\"

Either way, all the paths in the list need to be consistent.