请大家指教
解决方案 »
- 怎么实现这样的效果(高难度)
- 大家新年好!继续散分
- 请问用vb如何枚举系统正在运行的所有进程,我要判断是否开启了mmc进程
- 在线等, 如何把文本框填入的 458*(86+43)-25 的这样一个字符串运算得到的结果拿出来
- 有关一个WINSOCK和多线程的问题??如果能解决,我将以500分致谢!!(态度诚恳).希望能做的稳定点!
- vb的函数问题
- 基于vb的温度控制
- 如何获取一次网页访问中的各项详细时间数据
- 那位大哥给我发一份mdi窗体下的背景制作程序,到货后马上给分!
- VB6下载网页源码为什么会空白?
- 如何判断execute方法是否执行成功呢?
- 请问控件随窗口缩放的同时,控件中的字文大小如何随之缩放呢?
如果是11,是office2003
如果是9,是office2000
别的可以自己试试
http://blog.csdn.net/tanaya/archive/2005/04/29/368504.aspxPrivate Sub Command1_Click()
....
MsgBox GetInstalledOfficeVersion()
End SubFunction GetInstalledOfficeVersion() As String
On Error GoTo Z
Dim WD
Dim OfficeVer As String
OfficeVer = 0
Set WD = CreateObject("Word.Application.8")
OfficeVer = CStr(WD.Version)
WD.quit
Set WD = Nothing
If InStr(OfficeVer, "8") <> 0 Then
GetInstalledOfficeVersion = "Office 97"
ElseIf InStr(OfficeVer, "9") <> 0 Then
GetInstalledOfficeVersion = "Office 2000"
ElseIf InStr(OfficeVer, "10") <> 0 Then
GetInstalledOfficeVersion = "Office XP"
ElseIf InStr(OfficeVer, "11") <> 0 Then
GetInstalledOfficeVersion = "Office 2003"
End If
Exit Function
Z:
If Not WD Is Nothing Then Set WD = Nothing
GetInstalledOfficeVersion = "Office版本未知"
End Function
呵呵,上面的函数安装了Office2000,OfficeXP的机器上测试通过
MsgBox GetInstalledOfficeVersion()
End SubFunction GetInstalledOfficeVersion() As String
On Error GoTo Z
Dim WD
Dim OfficeVer As String
OfficeVer = 0
Set WD = CreateObject("Word.Application.8")
OfficeVer = CStr(WD.Version)
WD.quit
Set WD = Nothing
If InStr(OfficeVer, "8") <> 0 Then
GetInstalledOfficeVersion = "Office 97"
ElseIf InStr(OfficeVer, "9") <> 0 Then
GetInstalledOfficeVersion = "Office 2000"
ElseIf InStr(OfficeVer, "10") <> 0 Then
GetInstalledOfficeVersion = "Office XP 2002"
ElseIf InStr(OfficeVer, "11") <> 0 Then
GetInstalledOfficeVersion = "Office 2003"
End If
Exit Function
Z:
If Not WD Is Nothing Then Set WD = Nothing
GetInstalledOfficeVersion = "Office版本未知"
End Function
MsgBox GetInstalledOfficeVersion()
End Sub'本函数运行不需要机器上安装过Office
'经典的判断Office版本函数,原创!
'支持到Office 2003
Function GetInstalledOfficeVersion() As String
On Error Resume Next
Dim WD
Dim OfficeVer As String
OfficeVer = 0
GetInstalledOfficeVersion = ""
Set WD = CreateObject("Word.Application.8")
OfficeVer = CStr(WD.Version)
WD.quit
If Not WD Is Nothing Then Set WD = Nothing
If InStr(OfficeVer, "8") <> 0 Then
GetInstalledOfficeVersion = "Office 97"
ElseIf InStr(OfficeVer, "9") <> 0 Then
GetInstalledOfficeVersion = "Office 2000"
ElseIf InStr(OfficeVer, "10") <> 0 Then
GetInstalledOfficeVersion = "Office XP 2002"
ElseIf InStr(OfficeVer, "11") <> 0 Then
GetInstalledOfficeVersion = "Office 2003"
End If
If Err.Number = 424 Then
Err.Clear
GetInstalledOfficeVersion = "没有安装 Microsoft Office"
End If
End Function