Error while executing a procedure.

Hello 06035,

The error is most likely occurring in the beginning of your code with ChDir statement. Your path variable Folder hasn't been assigned a path.

Sincerely,
Leith Ross

Thanks for your replays.

Why are you using this [iColor] here?

Sorry my mistake, I wanted to color something in my code in this post, but then I have changed my mind and have forgotten to delete it. Of course I do not have this in my Excel VBA code.

so where do you define it?

Again my fault I have forgotten to give you this information.

I have defined variables in ThisWorkbook - Workbook - Open as follows:

Private Sub Workbook_Open()

template = Worksheets("Info").Cells(1, 12).Value
folder = Worksheets("Info").Cells(2, 12).Value
source = Worksheets("Info").Cells(3, 12).Value
End sub

And I have also in my module under General - Declarations

Public template As String
Public folder As String
Public source As String
Public where As String
Public name As String
Option Explicit

Hope I have made my mind clearer now.

Regards,
Patryk

maybe you should zip & attach the workbook.

Please find attached file. Let me know if the source file will be useful.

Regards,
Patryk