I have a macro. Right now the macro is troggered when a workbook is opened. however i want to put the macro on the network. so that it runs everyday at 10pm. how can i do that?
i have used windows scheduler but the problem is that there must be a dedicated computer for that or I have to locked my computer all the time. is there any way i can put my macro as an exe and it is run from the network everyday??
i have used windows scheduler but the problem is that there must be a dedicated computer for that or I have to locked my computer all the time. is there any way i can put my macro as an exe and it is run from the network everyday??
