I also added variable declarations to your original routines.
PasteSpecial 12 'Vals only ActiveWorkbook.
Along with VBA code where applicable.
The comment will be refreshed after
MsgBox "It seems some file was missing.
Last week, we learned how to use SQL and query data inside Excel.
Once you have received the verification code, you will be able to choose a new password for your account.