Your question: How do I make 1000 folders, then automatically number them

I need to make 1000 folders named Victor 001 - Victor 1000. How do i do it using a macro?

Do you need a VB macro? A simple(1) command line script could do the trick as well:

FOR /L %%i IN (1,1,1000) DO (IF %%i LSS 10 (mkdir "Victor 000%%i") ELSE (IF %%i LSS 100 (mkdir "Victor 00%%i") ELSE (IF %%i LSS 1000 (mkdir "Victor 0%%i") ELSE mkdir "Victor %%i")))

Just copy & paste into a batch file (e.g. create.bat) and run it from the directory where the subdirectories should be created. Please note that this is actually just one line, so make sure the command is not truncated by a newline or so.

(1) OK, looks a bit complicated because it was quite tricky to get the leading zeroes.