Good Day! I am using WaitScreenImage successfully on one of my computers, using a screenshot I took from SAP. The screenshot is just a notification that there is no data selected for the SAP script. When I compile the script as an EXE and include the image we're trying to locate, everything still wo...

I have a virtual machine that I share with a coworker. We have some scripts saved to a network drive that we run from the VM. When I log in to the VM and run our macros, everything works as expected. When my coworker tries to launch a macro, he gets the following error. Cannot create file "C:\Progra...

I have a Microsoft Access 2016 database set to hide the Navigation pane. I did this via Options > Current Database. When I open it manually and when I open it via MacroScheduler without calling a macro, the database opens as expected; The main form is displayed and the Navigation pane is hidden. If ...

Got it! function RunSAP(),result vbstart on error resume next If Not IsObject(application) Then Set SapGuiAuto = GetObject("SAPGUI") Set application = SapGuiAuto.GetScriptingEngine End If If Not IsObject(connection) Then Set connection = application.Children(0) End If If Not IsObject(session) Then S...

I have the following VB/VBEVAL code and all I want to do is get the result back from VB! I keep reading here and there in the forums that this can be done, but I am struggling. I just want to evaluate the result outside of VB. function RunSAP vbstart on error resume next If Not IsObject(application)...

Yeah, Marcus, you were right! Today the proper icon is there. It seemed far-fetched that the icon was somehow being stripped out.

All right, everybody relax. Everything's fine.

If I compile a macro into an executable and save it on my local drive, I get the exe with the icon I specified. If I copy/paste that .exe to a network location, the icon reverts back to the default icon. When I try to generate the .exe directly to a network location, the .exe is generated but the cu...

I am working on a script which needs to run an MS Access macro. Typically I do this with RunProgram> as ExecuteFile doesn't have a macro argument. My issue is that I won't know which version of MS Office the user will have. I guess I could look for MSACCESS.EXE in multiple folders, but it's harder t...

It's vintage, innit!

I'll look into an update.

I am having an issue where jobs which are only scheduled to run one time, once a day, are running over and over. They kick off at the scheduled time, complete the entire script, then instead of stopping, they run over and over until I intervene. Today a job sent out 300 emails before I got into the ...

Update: I started using My Documents instead of C:\ and things seem to be running properly without any interference from my antivirus.

Ugh, it looks like you're right (I can't be sure, though, because our endpoint protection is so robust that I can't seem to disable it to test.). I realized that the times when the job ran quickly were when I manually kicked off the job. It looks like when the job gets scheduled, the files get inter...

I rewrote the script to hold all of the programs for a single PO in a variable, so the WriteLine event only happens once per PO. It ran super fast the first couple of times I ran it but now it's running slow again. At the start of the job I delete all of the files in C:\tasklist\. I verified that al...

I have a script which retrieves data from a SQL table with the following structure. It then creates a text file for each PO and then uses WriteLine to populate them with the relevant Programs. This was running super fast last week, in 3-5 seconds. This week it can take between 3 and 11 minutes. Look...

You are a legend! Thanks, Marcus!