Run VBA when windows startup/shutdown/log on/log off

[Nishikawa]

Hi guys,

Is there any way to create a VBA module that runs certain shell command when user startup / shut down / log on / log off windows?

Thanks!!

 

[marleymanner1]

The shell command usually means that you're starting a program. If that's all you want to do, just present a task to windows and specify it to run at startup/shutdown/log on/log off. If you're using it with the logon/logoff functions, and you have multiple users, make sure to specify the option "only run when this user is logged on" appropriately. Use the start command with the full path of the executable file you want to run, write the line in a .txt file and save it as a .bat file. Use that file for the task. That is much simpler.

 

[Nishikawa]

Yup, This is one of the option that is feasible when all the computers are in my office. But I need Access to do it instead as this Access file will be circulated out of my country and i do not want each user to start configuring their computer when they know little about window schedule task.