Opening a file with a cell name

[joseoom]

I want to open a file with a macro that would have to change the name of the file every day.

The file I want to open has the name according to the day. What I need is for my macro to open every day with the name thats on cell A1.

What I thought, and didn´t work was:

Workbooks.Open Filename:="W:\Corretor\Operações\cells("P2").value.xls", Notify:=False

 

[Bruno_x]

Try this:
Workbooks.Open Filename:="W:\Corretor\Operações\" & range("P2") & ".xls", Notify:=False

 

[joseoom]

How can I change that code so that the content of the "P2" cell is used as value. Just because I need the format dd/mmm to be preserved.

 

[Bruno_x]

Workbooks.Open Filename:="W:\Corretor\Operações\" & format(range("P2"),"dd-mmm") & ".xls", Notify:=False

this will give you a filename like :
W:\Corretor\Operações\15-jan.xls.xls