View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default 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