LINK TO OPEN EXCEL FILE !

  • Thread starter Thread starter Jay Dean
  • Start date Start date
J

Jay Dean

I send an Excel Workbook as a Microsoft Outlook e-mail attachment to
some folks on my network. However the attached file sometimes get so
huge, so I have decided to place the Workbook in a network folder
accessible to everybody.

The problem is - this network folder contains so many files that the
people on my e-mail list would have to manually search for my Excel
file in the network folder.

Is there a way I can send the location of this file as a link in an
e-mail so that when anybody clicks on the link, the link would
automatically access and open the Excel file placed in the network
folder?

Any assistance would be greatly appreciated. Thanks!

Jay Dean
 
you can type in outlook:
file://server/share/path/document

outlook will make into a hyperlink.


i made a quick & dirty little macro and hope it works for you
which you can put in in your personal.xls

The URLencoded works in excel 2002
not in excel97
cant test in excel2000

wont work if book not saved...


Sub CopyUrl()
'This needs a reference to: Microsoft Forms Object Library
Dim dObj As New DataObject
dObj.SetText ("file:://" & ActiveWorkbook.FullNameURLEncoded)
dObj.PutInClipboard
End Sub


good luck!



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 
I still have two questions-

1. Will the file address format you provided automatically open the
Excel file when clicked on in the e-mail?

2. What exactly will the macro do if stored in the Personal.xls?

I just need some more clarification. Thanks.

Jay Dean
 
Jay...

save an xls in your c:\ directory called test.xls

open outlook, create email
type in body: file:///c:/test.xls

outlook converts it to a hyperlink...

now send the mail to yourself.
then from your inbox double click the link.

the macro (WITH THE CORRECTION TO 3 slashes) will copy the text for
a hyperlink pointing to the activeworkbook onto the clipboard.

so that in outlook you can paste the it into a new email.

if you've added it to personal.xls code,you can create a keyboard
shortcut via macro/options. say ctrlM (which is not used by excel)

in excel ctrl+M
in outlook ctrl+V




keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 
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
 
Jay..

ctrlV is standard windows shortcut for paste.

ctrlM is a keyboard shortcut you can assign to a macro,
via Macro/Options

about the slashes..
why dont you experiment a little on monday, and if 2 slashes work then
fine. if not add a third slash...

the popup about opening depends on several security settings in the
registry. your systems administrator at work will need to help you
there.

basically your whole question is out of scope for this newsgroup anyway.
it wasnt related to programming nor was it related to excel.
if anything it was related to outlook or windows.

dont expect to receive full solutions in newsgroups. you'll get pointed
in a direction...

you wanted a tip. you got it. (in fact you got a bit more)
now that you know where to look..


now it's up to you!






keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 
I've seen links with 4 slashes:

file:////server/share/filename.xls

And if that path/file contained spaces, you might have to replace them with
%20's.

file:////server/sharename%20with%20spaces/my%20documents/file%20has%20spaces.xls


(No, I don't know how many slashes are required--but 4 seems to work all the
time for me.)
 
Back
Top