on open

[izzyq]

Is it possible for me to manipulate this code such that if the filename is OPEX Variance Analysis rev.2.xls it will run the macro, otherwise, nothing will happen.

Here is the code that I have so far.

Option Explicit



Private Sub Workbook_Open()
Dim filename As String
If filename = "Y:\IQ38316\Data\Excel\OPEX-CAPEX Input Sheets\OPEX Variance Analysis rev.2.xls" Then

'set range you want to clear
Worksheets("Variance Analysis&quot.Range("K30:T53&quot.ClearContents

'returns OrgCode Values back to default "*" value
Worksheets("Variance Analysis&quot.Range("C8:C10&quot.Value = "*"

'returns month back to default of "01-January"
Worksheets("Variance Analysis&quot.Range("B1&quot.Value = "'01"

End If


End Sub

Help Me Obi Wan Kenobi, You're My Only Hope.

 

[euskadi]

Since you're in the workbook module, you can use this:

  if me.name = "bla bla bla.xls"