Error while executing a procedure.

Hi all,

I was working one a VBA procedure all day long and everything was fine, but suddenly every time I try to execute a procedure I got following error message:

"Compile error: Expected Function or Variable".

and Selection is beeing marked (see code)

I have no idea, what is the reason for this error massage.
I will appreciate any help.

My code is following (please be aware that I am a very beginner in VBA):

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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