Can you open a file where the name of that file is in a cell

[AdamParker]

Hello, I have some code where I would like to open a date-stamped file. I was wondering if it is possible to replace 05212008 with, for example cell A1. In A1 I would put =today() and format it accordingly. Any suggestions would be great, I really do not know where I could find some information similar to this, I have been looking on a lot of different sites and tried to look for others who may have had a similar problem but no luck.

Code is below, thanks for your time.

Please Login or Register  to view this content.

AdamParker

[VBA Noob]

Maybe

Please Login or Register  to view this content.

VBA Noob

[AdamParker]

Works like a charm! Thanks!