View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jay Dean Jay Dean is offline
external usenet poster
 
Posts: 154
Default LINK TO OPEN EXCEL FILE !



I tried what you suggested on some private pc just because I am not on
the network right now. I still have some questions.

1. When I try your suggestion and e-mail the file to myself and
double-click on it -- A File Download dialog box pops up which gives an
option to open the file. Is there a way to bypass this File Download
dialog box, or add some macro which automatically chooses "open" on
the File Dialog box?
** All I want is for my e-mail recipients to be able to click on the
e-mail link and "boom" -- the Excel file opens up!

2. Also, I noticed that on the file:///c:/test.xls
link in the e-mail you used (3 slashes). Does it mean that whatever
network path I use as a link in my actual e-mail will be of the form
file:///server/share/path/document (3 slashes before server) and NOT
file://server/share/path/document (2 slashes before server)?

3. Thirdly, what are the exact steps involved in the creation of the
shortcuts Ctrl+V (in outlook) and Ctrl+M (in Excel)?

I am still not very experieced in programming and I would appreciate
your clear explanation of these for me. Thanks.

Jay Dean


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!