XL Open help!

[SUnderwood]

Hi All,

My ASP routine hunts for an XL file with a given string in its name and provides them with a link to that document.

What I'd like to do now is open the XL file automatically without them having to click the link.

Any ideas? thanks

Sean

Business and Data Analyst
Database & Web Applications
International Applications Development
VB,VBA,ASP,SQL,Java,Pascal,ADA,SSADM,UML
Interested parties please email: seanunderwood1@hotmail.com

 

[mwolf00]

Heck - if you already have enough to write the HREF then you can just say

response.redirect "pageName.xls"

Am I missing something?

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

 

[SUnderwood]

If only it were so easy ;-)

I tried using this method, but some very odd URL is placed in the browser, being something like

<server path><file path>   - eg
\\intranet03\home\//server1/sharedfolder/dir/dir/sheet.xls

So, it produces an error. Anything else i could do?

Business and Data Analyst
Database & Web Applications
International Applications Development
VB,VBA,ASP,SQL,Java,Pascal,ADA,SSADM,UML
Interested parties please email: seanunderwood1@hotmail.com

 

[mwolf00]

Is the link that you create working properly?

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

 

[SUnderwood]

yep. amazingly ))

Business and Data Analyst
Database & Web Applications
International Applications Development
VB,VBA,ASP,SQL,Java,Pascal,ADA,SSADM,UML
Interested parties please email: seanunderwood1@hotmail.com

 

[mwolf00]

Can you post the code where you create the link and post the HTML it outputs?

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook (No, I'm not Rick)

 

[SUnderwood]

Thanks for the help mwolf00. The project has not finished and just having the link fitted the requirement sufficiently.

Its interesting though to note that, although the link in the reuslting html itself look like this

\\serevr\shared folder\dir\dir\sheet.xls

when redirect was used like this

respone.redirect MyLink

this was interpreted as

[URL unfurl="true"]http://intranet/\\serevr\shared[/URL] folder\dir\dir\sheet.xls

Quite strange.

Sean


Business and Data Analyst
Database & Web Applications
International Applications Development
VB,VBA,ASP,SQL,Java,Pascal,ADA,SSADM,UML
Interested parties please email: seanunderwood1@hotmail.com