HELP WITH VBA MACRO

I am looking for some help with a macro we created here in house, well the other sw guy here created most of it.

it takes data from a excel sheet and creates parts with the associated cell values as part name, size ect.

we do have a location set for the template part on the :C, but it calls out for the location of the folder that has the excel sheet.

the problem is it only works sometimes and it opens up 10 or more excel.exe. I have to start task manager and shut them down.

the other sw/programmer is stumped as well.

Thanks

SolidworksApi macros