diankb.cn    Excel表格教程



Excel表格-提取Flash方法

提取表格中的Flash文件


Sub ExtractFlash() Dim tmpFileName As String, FileNumber As Integer Dim myFileId As Long Dim myArr() As Byte Dim i As Long Dim MyFileLen As Long, myIndex As Long Dim swfFileLen As Long Dim swfArr() As Byte tmpFileName = Application.GetOpenFilename("office File(*.doc;*.xls),*.doc;*.xls", , "选择要提取FLash的office文件") If tmpFileName = "False" Then Exit Sub myFileId = FreeFile Open tmpFileName For Binary As #myFileId MyFileLen = LOF(myFileId) ReDim myArr(MyFileLen - 1) Get myFileId, , myArr() Close myFileId Application.ScreenUpdating = False i = 0 Do 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 If Loop myFileId = FreeFile tmpFileName = Left(tmpFileName, Len(tmpFileName) - 4) & ".swf" Open tmpFileName For Binary As #myFileId Put #myFileId, , swfArr Close myFileId MsgBox "以" & tmpFileName & "名字保存" End Sub


 

Excel表格中提取Flash方法: 复制以上代码



1.新建Excel表格,选择开发工具→Visual Basic或者Alt+F11。

2.再选择插入→模块→粘贴上面的代码(过程栏会显示“ExtractFlash”)→关闭(返回)

3.Alt+F8(宏名栏会显示“ExtractFlash”)→执行

4.选择需要提取Flash的Excel表格→打开

5.弹出“以*\*\*\*\.swf名字保存”→点击确认

6.返回原Excel表格位置,多出的同名swf后缀文件,为刚才提取的Flash文件。

使用过程中遇到问题,可联系开发者:回忆上了发条