'引用 Microsoft Common Dialog Controls 6.0
'点击菜单: 工程 -> 引用 -> 浏览 -> 文件类型:(ActveX 控件 *.ocx) -> COMDLG32.OCX
Private Sub Command1_Click()
Dim x As New MSComDlg.CommonDialog
x.Flags = cdlPDPrintSetup
x.CancelError = True
On Error GoTo ErrorHandle
x.ShowPrinter
Exit Sub
ErrorHandle:
If Err.Number <> 32755 Then
VBA.MsgBox Err.Number & ";" & vbCrLf & Err.Description
End If
End Sub
'点击菜单: 工程 -> 引用 -> 浏览 -> 文件类型:(ActveX 控件 *.ocx) -> COMDLG32.OCX
Private Sub Command1_Click()
Dim x As New MSComDlg.CommonDialog
x.Flags = cdlPDPrintSetup
x.CancelError = True
On Error GoTo ErrorHandle
x.ShowPrinter
Exit Sub
ErrorHandle:
If Err.Number <> 32755 Then
VBA.MsgBox Err.Number & ";" & vbCrLf & Err.Description
End If
End Sub
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货