I need to write a VB Macro that will run automatically every hour. Any ideas? Is this possible?
What do you mean exactly by a "VB macro"? Are we talking about the macro processing built into one of the MS Office products? (If so, which one?) Or getting Windows to run a VBScript, or an actual standalone Visual Basic program, or what? And what version of VB / VBA / VBScript?
Generally speaking, I'd say you probably should use the Windows task scheduling functionality to set this up, rather than expecting the "macro" to magically start itself up every hour. But without knowing more about the situation it's hard to advise.