-- 作者:dylinbin
-- 发布时间:2014/5/14 15:35:48
-- 帮忙修改一下VBA 代码实现 收盘后 自动补充数据 程序
金字塔用VBA 如何 实现 在指定时间 152000 到160000之间补充数据? 需要增加那些VBA代码?
Sub SJBC() if application.ReceiveDataStatus=0 then application.ReceiveData(1) Application.PeekAndPump application.SendMessage(33882) call application.Settimer(1,600000) call application.Settimer(2,9000000) Set Wrap = CreateObject("DynamicWrapper") Wrap.Register "user32.dll","FindWindowA","i=ss","f=s", "r=l" Wrap.Register "user32.dll","FindWindowExA","i=llss","f=s", "r=l" Wrap.Register "user32.dll","SendMessageA","i=lull","f=s", "r=l" h = Wrap.FindWindowA("#32770","数据接收") tab=Wrap.FindWindowExA(h,0,"SysTabControl32","") TCM_SETCURFOCUS=4912 WM_SETFOCUS=7 WM_KEYDOWN=256 WM_KEYUP=257 BM_CLICK=245 Wrap.SendMessageA tab,TCM_SETCURFOCUS,2,0 h1=Wrap.FindWindowExA(h,0,"#32770","自定义补数据") cb=Wrap.FindWindowExA(h1,0,"ComboBox","") Wrap.SendMessageA cb,WM_SETFOCUS,0,0 Wrap.SendMessageA cb,WM_KEYDOWN,VK_DOWN,0 Wrap.SendMessageA cb,WM_KEYUP,VK_DOWN,0 bt=0 bt=Wrap.FindWindowExA(h1,0,"Button","开始补充") Wrap.SendMessageA bt,BM_CLICK,0,0 if bt<>0 then todayhas=1 End Sub
|