Search found 35 matches

by AndrewT
Tue Jun 30, 2020 4:20 pm
Forum: Technical / Scripting
Topic: HTTPRequest not working in Compiled version
Replies: 14
Views: 5334

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: 14
Views: 5334

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: 14
Views: 5334

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: 14
Views: 5334

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: 14
Views: 5334

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: 14
Views: 5334

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: 14
Views: 5334

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: 940

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: 940

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: 807

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: 1058

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: 807

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...
by AndrewT
Sun May 03, 2020 2:52 pm
Forum: Technical / Scripting
Topic: Designing Radio Buttons
Replies: 3
Views: 1058

Designing Radio Buttons

I am trying to make two radio button objects dependent on each other, but I can't figure out how to reset or set a radio button from the code. I have tried to set the SelectedItem to null, an index value, and the actual value, but no luck. What I need is two radio button objects that are dependent o...
by AndrewT
Wed Aug 15, 2018 9:45 pm
Forum: Technical / Scripting
Topic: Setting variable to an Extended ASCII Character
Replies: 3
Views: 1325

Setting variable to an Extended ASCII Character

Why doesn't this code work?

Code: Select all

Let>fnd={Ascii(150)}
This also doesn't work.

Code: Select all

If>{%Target% = Ascii(150)}
I get the error "Unknown Identifier ASCII." How else can I set a variable to extended ASCII code?

Any help would be appreciated.

AndrewT
Sign up to our newsletter for free automation tips, tricks & discounts