Defining the variable to make code simplier

[maxon]

Hello Guys,

Could you please advice how to define below lines to make it simplier:

nome_file_master1 = "1011130800H - " & data_file6 & ".xlsx"

Workbooks.Open Filename:=ThisWorkbook.Path & "\" & data_anno & "\" & data_mese2 & "\" & data_file3 & "\RUSSELL\" & nome_file_master1 & ""

Set wb2 = Workbooks("1011130800H - " & data_file6 & ".xlsx").Sheets("Sheet1")

thanks!

 

[smozgur]

I would define wrk variable as a Workbook object and open the workbook by setting this object variable and use it in the following sections in the procedure:

Something like this:

Dim wrk as Workbook


nome_file_master1 = "1011130800H - " & data_file6 & ".xlsx"


Set wrk = Workbooks.Open(Filename:=ThisWorkbook.Path & "\" & data_anno & "\" & data_mese2 & "\" & data_file3 & "\RUSSELL\" & nome_file_master1 & “”)


Set wb2 = wrk.Sheets("Sheet1")

Note: I suggest defining all your variables as a good habit besides its advantages. I didn't do that in your code for your other variables - nome_file_master1, wb2

Suat