The easiest way to do this is just to stick all of your code into "Sub Main()" in a module, compile your EXE, and schedule it, like someone mentioned above. I do this quite frequently for all of my little utilities.. but i normally use VBScript for my "nightly tasks", just because i can make a change to it in the blink of an eye, and from any computer i might be at.
Just beware.. when you use the windows scheduling service, on NT4, Win2K, or whatever, you need to set the properties of your scheduled job to include the necessary network account/login - so that the job runs with the correct permissions for you to access network drives. And speaking of network drives, your network drives might not exist under this condition, and you may have to refer to the complete UNC (\\servername\share\path), or just remap your drive at the time of job execution.