Internet Explorer Open and Microsoft Edge Open behave differently in NON IE Mode - BLOCKER

%3CLINGO-SUB%20id%3D%22lingo-sub-2308051%22%20slang%3D%22en-US%22%3EInternet%20Explorer%20Open%20and%20Microsoft%20Edge%20Open%20behave%20differently%20in%20NON%20IE%20Mode%20-%20BLOCKER%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2308051%22%20slang%3D%22en-US%22%3E%3CP%3EInternet%20Explorer%20open%20Excel%20macro%20enable%20file%20in%20EXCEL-2016%20and%20keep%20the%20file%20path%20as%20https%20link.%20While%20in%20Edge%20Chromium%20it%20save%20in%20local%20drive%20and%20than%20open%20the%20file%20to%20lose%20link%20with%20https.%20At%20the%20end%20in%20EXCEL%20ThisWorkbook.path%20show%20local%20link%20instead%20of%20https%20link.%20How%20to%20resolve%20this%20issue%20when%20dealing%20with%20Microsoft%20Edge%20and%20Excel%20to%20keep%20the%20link%20intact%20with%20https.%20r%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOr%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20to%20open%20an%20EXCEL%20macro%20enabled%20file%20in%20EXCEL%20-%20I%20want%20to%20see%20that%20EXCEL%20open%20and%20still%20show%20path%20to%20it's%20original%20web%20link.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20HIT%20a%20MAJOR%20BLOCKER%20due%20to%20IE%20open%20dialog%20box%20misbehave.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EASP.NET%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESample%20Code%201%3A%3C%2FP%3E%3CP%3E%3CBR%20%2F%3Estring%20downloadpath%20%3D%20%22https%3A%2F%2F.......%2Ffolder%2Ffilename.xlsm%22%3B%3CBR%20%2F%3Esystem.diagonastics.process.start%20(download%20path)%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESample%20Code%202%3C%2FP%3E%3CP%3EPublic%20Void%20ProcessRequest(HttpContext%20context)%3CBR%20%2F%3E%7B%3CBR%20%2F%3EHttpResponse%20response%20%3D%20HttpContext.Current.Response%3CBR%20%2F%3EHttpReqeust%20request%20%3D%20context.Request%3B%3CBR%20%2F%3Estring%20session%20%3D%20HttpContext.Current.Session.SessionID%3B%3CBR%20%2F%3E.....%3CBR%20%2F%3E.....%3CBR%20%2F%3E.....%3CBR%20%2F%3Eresponse.ClearContent()%3B%3CBR%20%2F%3Eresponse.ClearHeaders()%3B%3CBR%20%2F%3Eresponse.Buffer%20%3D%20true%3B%3CBR%20%2F%3Eresponse.ContentType%20%3D%20file.ContentType%3CBR%20%2F%3Eresponse.BinaryWrite%20(file.FileData)%3B%3CBR%20%2F%3Eresponse.AddHeader(%22Content-Disposition%22%2C%22FileName%3DSomefilename.xlsm%22)%3B%3CBR%20%2F%3Eresponse.Flush()%3B%3CBR%20%2F%3E%7D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2312297%22%20slang%3D%22en-US%22%3ERe%3A%20Internet%20Explorer%20Open%20and%20Microsoft%20Edge%20Open%20behave%20differently%20in%20NON%20IE%20Mode%20-%20BLOCKER%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2312297%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1018466%22%20target%3D%22_blank%22%3E%40Malik1410%3C%2FA%3E%26nbsp%3BHello!%26nbsp%3B%20It%20sounds%20like%20the%20scenario%20is%20working%20as%20expected%20when%20using%20Internet%20Explorer.%26nbsp%3B%20Have%20you%20tried%20using%20MS%20Edge%20IE%20mode%3F%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fdeployedge%2Fedge-ie-mode%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fdeployedge%2Fedge-ie-mode%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Internet Explorer open Excel macro enable file in EXCEL-2016 and keep the file path as https link. While in Edge Chromium it save in local drive and than open the file to lose link with https. At the end in EXCEL ThisWorkbook.path show local link instead of https link. How to resolve this issue when dealing with Microsoft Edge and Excel to keep the link intact with https. r

 

Or

 

How to open an EXCEL macro enabled file in EXCEL - I want to see that EXCEL open and still show path to it's original web link.

 

We HIT a MAJOR BLOCKER due to IE open dialog box misbehave.

 

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

 

1 Reply

@Malik1410 Hello!  It sounds like the scenario is working as expected when using Internet Explorer.  Have you tried using MS Edge IE mode?  https://docs.microsoft.com/en-us/deployedge/edge-ie-mode