Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
open power point foils via excel button (link)
Hi folks,
I have following problem : I want to open a powerpoint presentation with a button or hyperlink from an excel workbook and jump automatically to the correct powerpoint foil. How can I do this? Althoug I have some generall knowledge about vba but this is way up to difficult for me :) Thanks, Ben |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why can't I open embeded power point document in excel | Excel Worksheet Functions | |||
Export excel file to power point. | Excel Discussion (Misc queries) | |||
link Excel / Power Point | Excel Discussion (Misc queries) | |||
pie charting through excel, using power point | New Users to Excel | |||
Cant close Excel App from Power Point | Excel Programming |