Using a query string in an excel hyperlink to an ASP.Net Web Application?

Clicking a link in Excel typically opens a new browser, and thus, a new session. There's nothing you can really do within Excel or the hyperlink to mitigate this - it's the way browser sessions work If you can't just re-initialize the user's session state when they access this url (I assume they may be asked to log in, etc. ) then maybe you could consider using cookies to retain the user's identity?

Clicking a link in Excel typically opens a new browser, and thus, a new session. There's nothing you can really do within Excel or the hyperlink to mitigate this - it's the way browser sessions work. If you can't just re-initialize the user's session state when they access this url (I assume they may be asked to log in, etc.) then maybe you could consider using cookies to retain the user's identity?

1 Yes it requires a login. I've not dug into that side of the application yet, it just seems strange that I can start a new browser window or tab myself and not need to login (when already logged in), but if I do it from Excel it doesn't seem to have access to what I presume is a cookie stored on the machine. I don't want to have to dig into the filesystem to open up a cookie just to duplicate this cookie for use by excel.It doesn't seem to me like the way browser sessions work, but more about how Excel works – Mark Burns Aug 19 '09 at 13:55.

I am having this same problem, and using Fiddler I can see that when following the link in Excel, cookies are not being sent to the server - causing session problems. My work around is as follows; create a redirect page that does not require a valid session, that just redirects to the page that requires a valid session. As the redirect page is in the browser - the page that is redirected to gets the session cookies as expected.

Code (redirect. Htm); Please wait, loading your page... Accessing the page from access using http://site-page/redirect. Htm?

Page=this-sub-page - works for me now.

I've just stumbled across this problem while using Firefox as my default browser. If I set IE as my default the issue goes away. This may not help in your case but it is a workaround.

I have also found out what causes the issue. Excel is requesting the page itself using IE7 before it passes the url to the default browser. This is a snippet from our server log: "GET /ar/vehicle.

Php? Rv_id=9046 HTTP/1.1" 302 - "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1 ... "GET / HTTP/1.1" 302 - "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1 ... "GET /? Q=node/57 HTTP/1.1" 200 6231 "-" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1 ... "GET /?

Q=node/57 HTTP/1.1" 200 8318 "-" "Mozilla/5.0 (Windows NT 5.1; rv:2.0) Gecko/20100101 Firefox/4.0 ... The first three lines are Excel sending the request and processing the redirect. The final line is what gets passed to the default browser. Gabriel.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.