Hello everybody.
I have completed 3 VBA macros in EB to update our EB data against our SAP data.
•The first macro should automatically update our EB data daily.
• The 2nd is identical, only for the manual start. This I have provided with a password that users can not start this.
•The 3rd macro is to update a project against the catalogs device master data. This macro is for the users.
As far as the macros work without problems.
Now my question:
How do I get the first macro into a routine that automatically cycles through it every day at a certain time? There are no queries in the macro as well as Msg.Box or similar. It only creates (like all 3 macros) a log-file. But it probably has to run under EB because the macro writes attributes back to the EB catalogs.
In addition, the macro is not protected against a start by a user. Which possibility exists there, since I can not lock a macro by the user control for these user groups. A password like in the second macro is not useful here because of the automatic run. Since the macro should run completely automatically in the background.
Is it possibility to start EB and the macro on the server via the Windows Task Scheduler and then close EB again after the macro run successful.
for possible answers
ever thank you in advance
I have completed 3 VBA macros in EB to update our EB data against our SAP data.
•The first macro should automatically update our EB data daily.
• The 2nd is identical, only for the manual start. This I have provided with a password that users can not start this.
•The 3rd macro is to update a project against the catalogs device master data. This macro is for the users.
As far as the macros work without problems.
Now my question:
How do I get the first macro into a routine that automatically cycles through it every day at a certain time? There are no queries in the macro as well as Msg.Box or similar. It only creates (like all 3 macros) a log-file. But it probably has to run under EB because the macro writes attributes back to the EB catalogs.
In addition, the macro is not protected against a start by a user. Which possibility exists there, since I can not lock a macro by the user control for these user groups. A password like in the second macro is not useful here because of the automatic run. Since the macro should run completely automatically in the background.
Is it possibility to start EB and the macro on the server via the Windows Task Scheduler and then close EB again after the macro run successful.
for possible answers
ever thank you in advance