VBA to Open File (filename contains current date) & copy Sheet to active workbook

[jlstidham]

I need help!
i'm trying to open a file where the filename contains the current date, (i.e. "report 8-12-2013). I have no problems opening it by adding the date but i'd like to be able to open it daily by just clicking button.
next i'd like to copy sheet 2 into my active workbook in tab named "data". can someone please help?!

[ajryan88]

Hi,

Place a button anywhere within your workbook (it doesn't have to be the "data" tab if you don't want it to be), and then use this code for the Click event:

Please Login or Register  to view this content.

Hope this helps

Don't forget to click the star and mark the thread as solved if I have helped you