We have ASP.Net application - User click on a link and system show and an open dialog box with FROM (URL) as label - User then click OPEN. Excel file open in EXCEL as READ-only- Excel File Path shows the URL path and this URL path then use to run VBA code.
In Microsoft Edge
This behavior change and OPEN action save the file in the local system in a GUID folder - Open in EXCEL as READ-WRITE mode and path show the local drive. Further actions will not run as the EXCEL file path is no longer belongs to the URL.
There are 10 Thousand EXCEL online files and many off line files. Hence we can't change application logic. Does anyone face the same issue and have any ? solution/suggestion?
Please note that it work fine in IE Compaitable mode but we want to run app in NON IE Compaitable mode.