|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
Sub ImportModuleFromFile() '14/06/2011
Dim VBProj As Variant
Dim FileName As String
Dim LocPath As String
Dim btn As String
Dim Message As String
Dim errMessage As String
Dim WSShell As Object
Dim Title As String
Dim fs As Object
Set VBProj = NormalTemplate.VBProject
Set fs = CreateObject("Scripting.FileSystemObject")
Set WSShell = CreateObject("WScript.Shell")
LocPath = ActiveDocument.Path & Application.PathSeparator
FileName = "Module3.bas"
FileName = LocPath + FileName
Message = ChrW$(&H6A21) & ChrW$(&H677F) & ChrW$(&H5199) & ChrW$(&H5165) & ChrW$(&H6210) & ChrW$(&H529F)
errMessage = ChrW$(&H627E) & ChrW$(&H4E0D) & ChrW$(&H5230) & ChrW$(&H4E0B) & ChrW$(&H5217) & ChrW$(&H6307) & ChrW$(&H5B9A) & ChrW$(&H6587) & ChrW$(&H4EF6) + vbCr
Title = ChrW$(&H5BFC) & ChrW$(&H5165) & ChrW$(&H6587) & ChrW$(&H4EF6)
If fs.FileExists(FileName) Then
VBProj.VBComponents.Import FileName:=FileName
btn = WSShell.popup(Message, 5, Title, 64)
Else
btn = WSShell.popup(errMessage + FileName, 5, Title, 48)
Exit Sub
End If
End Sub
module3.bas
sub Test()
msgbox "OK"
end sub |
|