In the attached file there is a button at the top of the MasterCopy sheet tab called "Create .xlsx From Selected for BEC" that saves selection (from column C) as an Excel .xlsx file to a specified location that is determined by the green button at the top of the sheet.
It saves the file but, how would I also save whatever the location is to a variable too? The user will give it a filename and the file saves, however I need that complete folder path and filename.xlsx to be used in another procedure in SAP. How would I get that? I need to populate a field in SAP with that location. Please advise and thanks.