79141367

Date: 2024-10-30 13:50:16
Score: 3
Natty:
Report link

I tested it using your code and it works ok, both with excel opened as when excel is not opened (so double click on the filename). See below image for code used. You can try using a DoEvents before the ActiveWorkbook.Close command.

enter image description here

Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • No code block (0.5):
  • Single line (0.5):
  • Low reputation (0.5):
Posted by: MyExcelDeveloper.com