Search found 38 matches

by AndrewT
Mon Feb 07, 2022 4:48 pm
Forum: Technical / Scripting
Topic: PHP Scripts
Replies: 1
Views: 2562

PHP Scripts

Does anyone run PHP scripts with MS? If so, wondering how to know when they are completed.
When I run them in Task Scheduler, the CMD window closes when the process completes, but this doesn't happen when I run them in CMD from MS.

Any help would be appreciated.

Andrew T.
by AndrewT
Thu Apr 08, 2021 3:27 pm
Forum: General Discussion
Topic: Dialog Editor off the screen
Replies: 8
Views: 15680

Re: Dialog Editor off the screen

The script fix worked for me. Thanks.

Sounds like I have the same setup as Grovkillen and the same issue. Not sure how repeatable it is for MS staff, but hopefully a fix can be made in upcoming versions because it is a truly frustrating problem.

Thanks again,

Andrew T.
by AndrewT
Thu Apr 08, 2021 1:52 pm
Forum: General Discussion
Topic: Dialog Editor off the screen
Replies: 8
Views: 15680

Dialog Editor off the screen

I am trying to edit one of my old program's dialog windows, but when I open the dialog editor, it opens the windows such that the top control bar is off the top of my monitor. I have tried all the tricks I know to move the windows, but because they open as a special child window of MS, I haven't had...
by AndrewT
Tue Jun 30, 2020 4:20 pm
Forum: Technical / Scripting
Topic: HTTPRequest not working in Compiled version
Replies: 18
Views: 29676

Re: HTTPRequest not working in Compiled version

Marcus, If the "Copy Runtime DLLs" box is checked during compiling of the exe, is that enough? Do the files also need to be in the same folder as the exe at runtime? I thought I had done both earlier, but I didn't get the DLLs from the MS Folder, I had gotten them through the instructions in the lin...
by AndrewT
Thu Jun 25, 2020 3:58 pm
Forum: Technical / Scripting
Topic: HTTPRequest not working in Compiled version
Replies: 18
Views: 29676

Re: HTTPRequest not working in Compiled version

You know what they say about a blind squirrel. :lol:

Andrew T.
by AndrewT
Thu Jun 25, 2020 3:36 pm
Forum: Technical / Scripting
Topic: HTTPRequest not working in Compiled version
Replies: 18
Views: 29676

Re: HTTPRequest not working in Compiled version

Found the problem, but don't really understand it. Changed the url from https to http and it works in both versions now. So maybe it has something to do with the first suggestion you gave me with the dlls and when I tried it, I didn't do something right. Not sure. But it seems to work now. Thanks fo...
by AndrewT
Thu Jun 25, 2020 3:05 pm
Forum: Technical / Scripting
Topic: HTTPRequest not working in Compiled version
Replies: 18
Views: 29676

Re: HTTPRequest not working in Compiled version

Upon your suggestion, I turned off my anti-malware and tried again. No joy. :cry:
by AndrewT
Thu Jun 25, 2020 2:40 pm
Forum: Technical / Scripting
Topic: HTTPRequest not working in Compiled version
Replies: 18
Views: 29676

Re: HTTPRequest not working in Compiled version

It is a NotifyMyDevice.com API service. It's a cool little website/app that I found out about digging around in the MS forum. Unfortunately there doesn't seem to be any Support tab for help. Still weird that I am running both instances on the same computer with different results. I have other compil...
by AndrewT
Thu Jun 25, 2020 1:46 pm
Forum: Technical / Scripting
Topic: HTTPRequest not working in Compiled version
Replies: 18
Views: 29676

Re: HTTPRequest not working in Compiled version

Unfortunately not. I tried it and no joy.
The response I get from the the HTTPRequest is:
Error connecting with SSL.
error:1407742E:SSL routines:SSL23_GET_SERVER_HELLO:tlsv1 alert protocol version

Any other ideas?

Andrew T
by AndrewT
Thu Jun 25, 2020 12:58 pm
Forum: Technical / Scripting
Topic: HTTPRequest not working in Compiled version
Replies: 18
Views: 29676

HTTPRequest not working in Compiled version

I have a short script that does a HTTPRequest Post. It works great when I run it from MS, but when I compile the code, everything but the HTTPRequest works. I am using the same computer for both runs.

Any ideas on what stupid thing I am overlooking this time?

Andrew T
by AndrewT
Mon May 18, 2020 3:32 pm
Forum: Technical / Scripting
Topic: XLGetSelectedCell
Replies: 2
Views: 2883

Re: XLGetSelectedCell

**Update**
Upgrading to V15.0.09 seems to have fixed the compiled program.

Still a discrepancy between the Code Builder and Command Reference. Looks like the Code Builder format is the correct one.
by AndrewT
Mon May 18, 2020 2:59 pm
Forum: Technical / Scripting
Topic: XLGetSelectedCell
Replies: 2
Views: 2883

XLGetSelectedCell

I have a new program using the XLGetSelectedCell command and it works on my computer (Windows 10, Excel 2016) when run from MS, but when I compile the program and run it doesn't return values and doesn't throw an error. I am running MS V15.0.08. Upon further investigation, I noticed a discrepancy be...
by AndrewT
Mon May 04, 2020 6:47 pm
Forum: Technical / Scripting
Topic: CSV Query Problem
Replies: 2
Views: 2758

Re: CSV Query Problem

***SOLVED***
The answer is to use a Schema file. I believe that CSV queries without schema files default to the format of the first line of data. Since the first row of the column in question was 0, and not 0.00, the default became integer instead of decimal.

Andrew T
by AndrewT
Mon May 04, 2020 6:34 pm
Forum: Technical / Scripting
Topic: Designing Radio Buttons
Replies: 3
Views: 3485

Re: Designing Radio Buttons

Thanks JRL!
The logic is basically what I had figured out, but it was the setting ItemIndex to -1 instead of the SelectedItem property that I needed.

Andrew T
by AndrewT
Mon May 04, 2020 5:03 pm
Forum: Technical / Scripting
Topic: CSV Query Problem
Replies: 2
Views: 2758

CSV Query Problem

Has anyone else had a problem when querying a CSV file that small negative numbers return as zero? Or truncating values in particular columns? I have a CSV file that has a column with mostly zeroes in it, with the occasional small negative decimal (ie. -0.15). When I do a Sum of that column, the res...
Sign up to our newsletter for free automation tips, tricks & discounts