|
Home > Archive > IIS ASP > May 2004 > How to create a URL and when user clicks it to open a Excel workbook
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to create a URL and when user clicks it to open a Excel workbook
|
|
| Belinda 2004-05-30, 11:54 am |
| Hello All
I want to place a Excel workbook on the web server and create a URL
link to it and when the user clicks on it to the URL/vbscript behind
it must launch Excel on the client and open the URL linked Excel
workbook automatically.
Can you please share the code HTMl & VB script snippet that can do
this.
Thanks
Belinda
| |
| Anne Troy 2004-05-30, 11:54 am |
| Hi, Belinda. This is a machine setting (whether IE or Excel is used to open
a workbook on a website), and I don't believe that it's controllable with
VBA or any other kind of script.
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Web: New! www.VBAExpress.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
"Belinda" <belindacur@yahoo.com> wrote in message
news:41af5e48.0405281507.77948d9e@posting.google.com...
> Hello All
>
> I want to place a Excel workbook on the web server and create a URL
> link to it and when the user clicks on it to the URL/vbscript behind
> it must launch Excel on the client and open the URL linked Excel
> workbook automatically.
>
> Can you please share the code HTMl & VB script snippet that can do
> this.
>
> Thanks
> Belinda
| |
| Tushar Mehta 2004-05-30, 11:54 am |
| Just put the workbook on the server and on any page a link to it as you
would a link to anything else, for example, <a href="xyz.xls">Here's
the XL workbook</a> What happens next depends on the visitor. If XL
is installed on their machine and tney just click on the link, and
various file associations are set correctly, XL will indeed start up
and open the file. However, I, for one, would never click on a link
and open a workbook 'automatically.' If I decide I want to look at the
file, it would be downloaded to my computer and checked for viruses
before being opened with macros disabled.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <41af5e48.0405281507.77948d9e@posting.google.com>,
belindacur@yahoo.com says...
> Hello All
>
> I want to place a Excel workbook on the web server and create a URL
> link to it and when the user clicks on it to the URL/vbscript behind
> it must launch Excel on the client and open the URL linked Excel
> workbook automatically.
>
> Can you please share the code HTMl & VB script snippet that can do
> this.
>
> Thanks
> Belinda
>
|
|
|
|
|