1、打开excel2003，新建一个excel文档，单击工具->宏->Visual Basic 编辑器按钮，在弹出的窗口中粘贴后面的VB代码。
2、VB代码：Sub ExtractFlash()Dim tmpFileName 钽吟篑瑜As String, FileNumber As IntegerDim myFileId As LongDim myArr() As ByteDim i As LongDim MyFileLen As Long, myIndex As LongDim swfFileLen As LongDim swfArr() As BytetmpFileName = Application.GetOpenFilename("office File(*.doc;*.xls),*.doc;*.xls", , "确定要分析的 Office 档")If tmpFileName = "False" Then Exit SubmyFileId = FreeFileOpen tmpFileName For Binary As #myFileIdMyFileLen = LOF(myFileId)ReDim myArr(MyFileLen - 1)Get myFileId, , myArr()Close myFileIdApplication.ScreenUpdating = Falsei = 0Do While i < MyFileLen If myArr(i) = &H46 Then If myArr(i + 1) = &H57 And myArr(i + 2) = &H53 Then swfFileLen = CLng(&H1000000) * myArr(i + 7) + CLng(&H10000) * myArr(i + 6)+CLng(&H100) * myArr(i + 5) + myArr(i + 4) ReDim swfArr(swfFileLen - 1) For myIndex = 0 To swfFileLen - 1 swfArr(myIndex) = myArr(i + myIndex) Next myIndex Exit Do Else i = i + 3 End If Else i = i + 1 End IfLoopmyFileId = FreeFiletmpFileName = Left(tmpFileName, Len(tmpFileName) - 4) & ".swf"Open tmpFileName For Binary As #myFileIdPut #myFileId, , swfArrClose myFileIdMsgBox "以" & tmpFileName & "名字保存"End Sub
3、粘贴好了以后返回到excel主界面，把该excel文档起一个你容易辨识的名字，保存为“提取swf”，留着用来提取swf文件。打开嵌入了swf文件的ppt，在swf文件上右键单击，选择复制，新建一个excel文件，在新建的excel文件里右键“粘贴”，把ppt里的swf文件复制过来，起个名字，保存为excel 97—2003工作薄(*.xls)（这里面的版本选择很重要，不要选错），保存好了关闭该excel。
4、打开我们第一个粘贴有代码的excel文档——提取swf.xls，在“工具”菜单下，单击“宏”-> “宏”，弹出宏对话框，单击“执行”，在打开的窗口中选择粘贴有swf文件的excel文件，大功告成，里面的swf马上就会被提取出来，不信，你试试！
