View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Sean Howard Sean Howard is offline
external usenet poster
 
Posts: 11
Default open power point foils via excel button (link)

Dear Benjamin

Try using the .Hyperlinks method of the worksheet object. The folowing
will create a hyperlink to a PowerPoint presentation in the activecell.
You do not need the SubAddress and if the ScreenTi is left empty it will
display the full path of the presentation:-


ActiveSheet.Hyperlinks.Add _
Anchor := ActiveCell, _
Address := "<<file path of presentation", _
SubAddress := "", _
ScreenTip := "", _
TextToDisplay := "<<text displayed in the cell"

Hope it helps

Sean

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