[unisog] Anyone got a script that will detect bad excel files?

Michael Holstein michael.holstein at csuohio.edu
Wed Jun 21 18:41:33 GMT 2006


> Anyone know of any useful docs?

This looks promising .. (but it's VB code) :

http://sniptools.com/tipstricks/deleting-all-hyperlinks-from-a-microsoft-office-document

This VB snippit will deactivate all hyperlinks in an excel document :

--snip--
sub RemoveHyperLinksGLobally()
     Dim i As Integer
     For i = ActiveSheet.Hyperlinks.Count To 1 Step -1
           ActiveSheet.Hyperlinks(i).Delete
     Next i
End Sub
--snip--

I've been searching CPAN, but the Spreadsheet::ParseExcel modules don't 
handle Hyperlinks yet...

Cheers,

Michael Holstein CISSP GCIA
Cleveland State University


More information about the unisog mailing list