If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to create a URL and when user clicks it to open a Excel workbook
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 |
#2
|
|||
|
|||
How to create a URL and when user clicks it to open a Excel workbook
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" wrote in message om... 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 |
#3
|
|||
|
|||
How to create a URL and when user clicks it to open a Excel workbook
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 , 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 |
Thread Tools | |
Display Modes | |
|
|