I have a report that needs to be refreshed on the 10th of each month. I need to have this automated so I don't have to do anything. There are two worksheets within the file that will be refreshed. The file is currently in a SharePoint site but my development team is looking to make it so it is opened up on the time frame that I need it so the macro can run for running the refresh can run. The issues is I don't the macro to refresh the file if it is open before the date needed.
Can you help me with the macro that I need to put in place.
Can you help me with the macro that I need to put in place.