0

We have ASP.Net application - User clicks on a link and system show and an open dialog box with FROM (URL) as a label - User then clicks 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 offline files. Hence we can't change application logic. Does anyone face the same issue and have any? solution/suggestion?

Please note that it works fine in IE Compatible mode but we want to run the app in NON-IE Compatible mode.

Improve this question
11
  • Which version of Edge are you using? I try to open excel files in IE and Edge Chromium, but the behaviors are the same. Could you please provide a minimal code example which can reproduce the issue? I think it can help us to understand the issue better, then we can see how to help.
    – Yu Zhou
    Commented Apr 7, 2021 at 2:55
  • Edge version is 89.0.774.45
    – Malik
    Commented Apr 7, 2021 at 18:26
  • I will get the code tomorrow. As I explained above that when user click on link than a URL will build with fulll File name. Browser show dialog box, user click on open..Both browsers open the file (IE open file but workbook path still show URL not any local folder-This is what we want)...Chromium download the file in random local folder after saving file and eventually show local path. In this logic next code can't figure out that from which path this file downloaded and where to get next file.
    – Malik
    Commented Apr 7, 2021 at 18:30
  • Hi, how about the issue? You can come back anytime when you have the code.
    – Yu Zhou
    Commented Apr 9, 2021 at 8:14
  • Issue is still exists - Microsoft seems know about it but not found any solution. Sorry got busy to bring sample code.. Let me get this today
    – Malik
    Commented Apr 29, 2021 at 10:30
Related questions
1
Strange behaviour opening pop-up window in Internet Explorer
3
Weird IE behavior on dialog open
1
IE Automation using Excel VBA: anchor.click calling a function not working javascript web dialog box
Load 7 more related questions Show fewer related questions

0

Reset to default