excel中导出flash

1.   点击工具——>宏——>宏

2.     弹出一个宏创建窗体,在窗口中输入宏名（例如：宏名：ExtractFlash）点击创建按钮。

3.     弹出一个编程界面，在界面的中间有一个小窗口，在窗口中输入下面的程序段。

<script type="text/javascript"><!--google_ad_client = "pub-2616259956670917";/* Sky_VS_Moon文章中间文字链 */google_ad_slot = "8121140709";google_ad_width = 728;google_ad_height = 15;// --></script><script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"></script>

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

4.     按F5运行宏。

5.     弹出一个选择文件的窗口，选择你想要提取flash的excel文件，点击打开按钮。

6.     这时会弹出一个提示窗口“以。。。。名字保存”，点击确定。

7.     在excel所在的位置会产生一个同名的flash文件。到此flash文件已经导出了