开发者

How do i create a routine that would constantly run in the background?

开发者 https://www.devze.com 2022-12-21 05:04 出处:网络
I am making a primitive database in Excel and need a routine to run in the background constantly. I will be able to fill in 开发者_开发技巧the actual actions it needs to do, but I don\'t know how to m

I am making a primitive database in Excel and need a routine to run in the background constantly. I will be able to fill in 开发者_开发技巧the actual actions it needs to do, but I don't know how to make something run independent of a key press or some sort of Macro. If someone can give me an example of code that runs independently which I can simply fill with contents, that would be much appreciated.


Try this http://www.ozgrid.com/Excel/run-macro-on-time.htm


I haven't worked with VBA for quite some time now, but you would have to create a thread in VBA, maybe by COM-Threading, but I am not too sure if Excel is threadsafe or if you even can use Threads of some kind in Excel. Another alternative would be a Timer. If it is not implemented in VBA and I don't remember it to be, you would have to create the Timer yourself and react to the Windows Message yourself, if you can do that in VBA.

All in all I think this uses case might be to big for an Excel VBA Macro. If I were you I would consider doing this in a different way.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号