MACRO to Open Specific Workbook Each Day

[fben96]

Hey All,

I have a question regarding a macro that will automate some data fill. Each day my team receives an email with a workbook named "Data-Today's Date ", I open up the workbook copy some data and place it in a workbook named "Data Tracker". I know how to write a macro that will fill "Data Tracker" from from a workbook that's name doesn't change. But we pull data from a new workbook each day with the days date.

Any help would be appreciated.

[nankw83]

Hi fben96,

One way ...

Please Login or Register  to view this content.

[fben96]

Thank you!

[nankw83]

Glad to help ... If that takes care of your original question, please take a moment & mark this thread as [SOLVED] from the Thread Tools above your first post & consider * Add Reputation to those who have helped by clicking the star icon under their usernames

[fben96]

One quick question before resolving, is there a way to define location of the file? The files whose name changes lives on Microsoft teams. Is there a way to define that? If not, I can probably set up an auto email and auto save for it to work.

[AliGW]

Is your user profile up-to-date? From your comments, I suspect you are using Excel 365, not Excel 2010 - if so, please update this here. Thanks.

[fben96]

Yes it is Microsoft 365. My apologies, haven't posted in awhile!

[nankw83]

is there a way to define location of the file? The files whose name changes lives on Microsoft teams.

You can define the file path as shown below ... I am not sure if MS Teams has a folder/file path though

Please Login or Register  to view this content.