I have a forecast file that I’m going to share email to people for their business unit at the start of the year.
Each month, I will email them another data file containing data that changes on a monthly basis.

Currently in the forecast file we have a button that shows a message saying:
‘Ensure your ‘data file’ is open and Press CTRL + SHIFT + I to import update your forecast file’. This works really well at the minute after testing but is a 2 step process and there are potential pitfalls (such as if the person has the previous forecast file open).

Is there a way to get this import to happen on the press of the button given neither filename are fixed as they will include the BU name and dates. I think this rules out the Application.Run option but am happy to be told otherwise.

Many thanks