Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.inetserver.asp.general,microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.excel.links,microsoft.public.inetexplorer.scripting
external usenet poster
 
Posts: 23
Default 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   Report Post  
Posted to microsoft.public.inetserver.asp.general,microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.excel.links,microsoft.public.inetexplorer.scripting
external usenet poster
 
Posts: 16
Default 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   Report Post  
Posted to microsoft.public.inetserver.asp.general,microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.excel.links,microsoft.public.inetexplorer.scripting
external usenet poster
 
Posts: 1,071
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Double clicks do not open the file Aggie Excel Discussion (Misc queries) 1 November 12th 07 10:42 AM
How to have errr msg pop up when user clicks on locked cell perfection Excel Discussion (Misc queries) 4 May 29th 07 06:27 AM
Open an Outlook folder when a user clicks on a command button ... Rob Keel Excel Discussion (Misc queries) 2 August 1st 05 08:23 AM
unable to open Excel file by double clicks Renyan Excel Discussion (Misc queries) 2 January 16th 05 01:07 AM
Excel not warning if another user has the workbook open Edward Chalk Excel Programming 2 July 21st 03 06:18 AM


All times are GMT +1. The time now is 02:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"