Automating Logicim XLGL tasks on a schedule

Automating XLGL tasks

You can use the Windows scheduler to automate tasks in Logicim XLGL. For example, you may want to update a report once a day and email it or save a copy to a specific folder.

Steps

Follow these steps to automate your task:

1. Create (or record) a macro that will automate everything that your task requires. Reference the article on using Logicim XLGL in a VBA macro for specific ways to use XLGL in a macro. Here's an example of a macro that Connects XLGL, Refreshes the report, then closes Excel:

1. Replace CONNECTION_NAME, USERNAME, and PASSWORD with your specific connection information.
2. Create a new task in the Windows task scheduler and set the Action to start a program
3. The executable for the Task is C:Program files (x86)LogicimXLGLAutomateXLGL.exe
4. The arguments are the full path, the workbook, and the macro name. For example: “C:TestMyTest.xlsm” AutomateTest

Testing the automation

You should test your automation before changing any other settings. In particular, the automation task must run in a regular user account (user logged in and without maximum privilege).

Additional help

Creating macros for automation is an advanced feature of Excel. Contact us if you would like some help with your macro creation.