Dll Not Found/Missing Error------Repair You Dll Errors : How to Fix Problem - Loop macro to go through list and save files?

Loop macro to go through list and save files

I have a model inwhich the user selects the input in E3 via a data validation list based off a named range entitled 'employees' I need to create a loop macro that runs through my 'employees' range, updates the model for each employee and then saves each
individual employee file in a specified location.

Thanks!

Keys to the Problem Loop macro to go through list and save files

Download SmartPCFixer for Free Now

Something like this:

Sub MakeFiles()
Dim C As Range
For Each C In Range("Employees").Cells
    Range("E3").Value = C.Value
    Application.Calculate
    ActiveWorkbook.SaveCopyAs "C:\MyPath\" & C.Value & ".xlsx"
Next
End Sub

In this method we will try to Boot in Safe mode with Networking and see if the error still persists.

Search "MSCONFIG" and Open.
Click on Boot Tab
Tick Safe Boot in Boot Option
Select Network.
Click Apply and OK.
Reboot your System.

Another Safe way to Fix the Problem: Loop macro to go through list and save files:

How to Fix Loop macro to go through list and save files with SmartPCFixer?

1. You can Download SmartPCFixer here. Install it on your computer. When you open it, it will perform a scan.

2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in SmartPCFixer. Like dll downloading, junk file cleaning and print spooler error repair.