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


(Jay Dean) wrote:

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

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

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

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


jay dean wrote:



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

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

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!

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


jay dean wrote:



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!

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.)
keepitcool wrote:

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

jay dean wrote:



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!


--

Dave Peterson

Thanks. I appreciate all your help !

Jay Dean

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