[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) :


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

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

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


Michael Holstein CISSP GCIA
Cleveland State University

More information about the unisog mailing list