Excel精英培训网

 找回密码
 注册
数据透视表40+个常用小技巧,让你一次学会!
查看: 3705|回复: 0

获取弹出内置框句柄

[复制链接]
发表于 2019-3-31 10:26 | 显示全部楼层 |阅读模式
1学分
下面代码在内置打印窗口弹出后,就没有反应了。请哪位大师帮帮忙,谢谢!

'定义GetForegroundWindows API 获取最前面窗体
Declare Function GetForegroundWindow Lib "user32" () As Long
Declare Function SetWindowPos& Lib "user32" _
    (ByVal hwnd As Long, ByVal hWndInsertAfter As Long, ByVal X As Long, _
    ByVal Y As Long, ByVal cx As Long, ByVal cy As Long, ByVal wFlags As Long)
Const HWND_BOTTOM = 1, SWP_NOSIZE = &H1, SWP_NOMOVE = &H2
Sub jspjb()
    Application.Dialogs(9).Show '打开对话框
    Application.Wait Now + TimeValue("00:00:02")
    hwnds = GetForegroundWindow()
    SetWindowPos hwnds, HWND_BOTTOM, 0, 0, 0, 0, SWP_NOSIZE Or SWP_NOMOVE
     '执行其它代码!

End Sub

excel精英培训的微信平台,每天都会发送excel学习教程和资料。扫一扫明天就可以收到新教程
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )

GMT+8, 2024-5-17 02:11 , Processed in 0.204633 second(s), 8 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表