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
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