Thread
:
LINK TO OPEN EXCEL FILE !
View Single Post
#
2
Posted to microsoft.public.excel.programming
keepITcool
external usenet poster
Posts: 2,253
LINK TO OPEN EXCEL FILE !
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
Reply With Quote
keepITcool
View Public Profile
Find all posts by keepITcool