I am trying to get a file to open as a function of a macro where the filename needs to be dynamic by date. There is no option to change how the reference file is saved, so the file with the macro has a cell with a formula that does this: ="\\server\subserver\folder\subfolder\subsubfolder"&"\ParentFile"&TEXT(TODAY(),"MM")&"_"&TEXT(TODAY(),"DD")&"_"&TEXT(TODAY(),"YY")&".xlsm" But I cannot get that to work in the VBA code...it errors out.

Need to open the file using that reference... Not married to the Workbook.Open Filename code, but it's what I know...

Any help is greatly appreciated.

Mel.