Share
Report
52Hello,
I have created a gallery in which is a selection to do an analysis. If analysis is selected, an Analysis Excel Template from OneDrive is opened. After the analysis is done, the file is saved to OneDrive. In other words, there are as many analysis excel files as there are items in the gallery, which have the analysis option selected.
In the gallery I have an ID column, which is just an unique number to identify the items. I would like to add this ID in the Analysis Excel Template name after the analysis is done in Excel, in order to find the right analyses afterwards. For example I would like to have ID+Excel Template name such as "1000Analysis.xlsx".
So how can I do this? If its not possible to directly save the file with ID included in the filename, is it possible to import the ID data to Excel, and then save the file with an Excel macro?
Thanks!
All responses (
Answers (
