question

38553939 avatar image
0 Votes"
38553939 asked YuZhou-MSFT commented

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

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.


dotnet-csharpms-edge
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.


Which application logic of ASP.NET application you do not want to change?

0 Votes 0 ·

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.

0 Votes 0 ·

@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.

0 Votes 0 ·

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.

0 Votes 0 ·

1 Answer

cheong00 avatar image
0 Votes"
cheong00 answered YuZhou-MSFT commented

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.


· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·

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();
}

0 Votes 0 ·
Show more comments