Microsoft IE open dialog Box and Microsoft Edge Open Dialog Box Different in behavior need help

Malik Mehmood 1

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.

Viorel 114K Reputation points

2021-04-06T16:37:08.013+00:00

Which application logic of ASP.NET application you do not want to change?
Malik Mehmood 1 Reputation point

2021-04-06T16:43:54.247+00:00

We have an in-house build application and portal - There is no solution found to replicate the same behavior in a new browser that is already working.
Emily Hua-MSFT 27,571 Reputation points

2021-04-07T02:20:10.997+00:00

@MalikHassan-1270
As tag "office-excel-itpro" means general issues of Excel desktop app, but your issue is not related to Excel desktop app, I would remove this tag.
Thanks for your understanding.
Yu Zhou-MSFT 12,621 Reputation points Microsoft Vendor

2021-04-07T03:03:38.487+00:00

Hi @MalikHassan-1270

I saw that you have asked the same question in stackoverflow.
I'll reply you in stackoverflow.
Here you can wait to see if there're any other community members have different opinions.

1 answer

Cheong00 3,471 Reputation points

2021-04-07T02:30:54.897+00:00

If no other things work, you can always add Content-Disposition: attachment; filename="filename.xlsx" header to let user save it in ordinary local folder before open it. Your VBA scripts should continue to work this way.
Please sign in to rate this answer.
Malik Mehmood 1 Reputation point

2021-04-07T18:16:32.2+00:00

Thanks for response - Please note issue is that EDGE not opening file the way IE open the file. We want to make sure that when we check EXCEL workbook path that it should indicate URL from where it link or open. Microsoft Edge download file in temp folder than open from local folder and provide local path. This create problem for next action required on the file based on URL.

Cheong00 3,471 Reputation points

2021-04-08T10:03:14.783+00:00

See if you can get any luck with Workbook.FullName. Someone got the problem with inverted direction.

Malik Mehmood 1 Reputation point

2021-04-29T16:54:23.653+00:00

ASP.NET

Sample Code 1:

string downloadpath = "https://......./folder/filename.xlsm";
system.diagonastics.process.start (download path);

Sample Code 2

Public Void ProcessRequest(HttpContext context)
{
HttpResponse response = HttpContext.Current.Response
HttpReqeust request = context.Request;
string session = HttpContext.Current.Session.SessionID;
.....
.....
.....
response.ClearContent();
response.ClearHeaders();
response.Buffer = true;
response.ContentType = file.ContentType
response.BinaryWrite (file.FileData);
response.AddHeader("Content-Disposition","FileName=Somefilename.xlsm");
response.Flush();
}

Yu Zhou-MSFT 12,621 Reputation points Microsoft Vendor

2021-05-04T02:56:04.85+00:00

Hi @Malik Mehmood I've replied to you on this stackoverflow thread. You can focus on the stackoverflow thread if you have any feedback.
Sign in to comment

Share via

Microsoft IE open dialog Box and Microsoft Edge Open Dialog Box Different in behavior need help

1 answer