|
‘在窗体中用ComboBox下拉选择打印机
- '===============下拉选择打印机
- Private Sub ComboBox1_Change()
- Dim s$, ws As Object
- s = ComboBox1.Text
- Set ws = CreateObject("wscript.network")
- ws.SetDefaultPrinter s
- End Sub
- '===============窗体初始化生成打印机下拉列表
- Private Sub UserForm_Initialize()
- Dim i&, ws As Object, ptn$, arr() As String, n&, m&
- Set ws = CreateObject("wscript.network")
- n = ws.EnumPrinterConnections.Count
- ReDim arr(1 To n / 2)
- For i = 1 To n - 1 Step 2
- ptn = ws.EnumPrinterConnections.Item(i) '打印机名称
- m = (i - 1) / 2 + 1
- arr(m) = ptn
- Next
- Me.ComboBox1.List = Application.Transpose(arr)
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|