VBA to check file name of active workbook

[Kayslover]

Hi all,

I have a macro that opens a file, calls another macro using the Call statement (Call E_DoRepeatWork_AllWorkbooks).

The called macro does processing and one of the last statements in this macro is to close the active workbook, and then return from where it come from.

What I need to achieve in E_DoRepeatWork_AllWorkbooks is, if the current file name is "12 December" (or even check the first 6 characters, if its faster) then NOT to close the active workbook.

Is what I am asking for possible?

Any assistance offered will be appreciated.

 

[offthelip]

It is very easy to check the actrive workbook name : like this:

Dim sts As String
sts = ActiveWorkbook.Name
If Left(sts, 6) = "12 Dec" Then
 MsgBox (sts)
Else
 ActiveWorkbook.Close
End If

 

[Kayslover]

Offthelip,

Many thanks, worked a treat as expected. ? ?