Breaking PowerPoint links with VBA from within Excel.

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I have a PowerPoint file linked to an Excel spreadsheet. Does anyone
have a subroutine that breaks the links to PowerPoint with VBA code
from inside Excel? This must be done from Excel.

Other postings I have found give subroutines that only work from within
PowerPoint.

I appreciate any help.

Thanks,
Tim
 
This will remove ALL hyperlinks from your workbook. You will want to add
criteria to selectively delete links.

====Begin Code========

Sub Patties()
Dim oSht As Worksheet
Dim oLink As Hyperlink

For Each oSht In ActiveWorkbook.Sheets
For Each oLink In oSht.Hyperlinks
oLink.Delete
Next oLink
Next oSht

End Sub

====End Code========


--
Bill Dilworth
Microsoft PPT MVP Team
Users helping fellow users.
===============
Please spend a few minutes checking vestprog2@
out www.pptfaq.com This link will yahoo.
answer most of your questions, before com
you think to ask them.

Change org to com to defuse anti-spam,
ant-virus, anti-nuisance misdirection.
..
..
 
I have a PowerPoint file linked to an Excel spreadsheet. Does anyone
have a subroutine that breaks the links to PowerPoint with VBA code
from inside Excel? This must be done from Excel.

Other postings I have found give subroutines that only work from within
PowerPoint.
Click to expand...

The same code will work from within Excel with a few mods.

Driving Excel from PowerPoint. Driving PowerPoint from Excel. And so on.
http://www.rdpslides.com/pptfaq/FAQ00368.htm
 
Back
Top