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...

You know what they say about a blind squirrel.

Andrew T.

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...

Upon your suggestion, I turned off my anti-malware and tried again. No joy.

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...

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

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

**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.

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...

***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

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

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...

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...

Ok, I guess I was misunderstanding this.

https://www.mjtnet.com/manual/index.html?ascii.htm

AndrewT

Why doesn't this code work?
This also doesn't work. I get the error "Unknown Identifier ASCII." How else can I set a variable to extended ASCII code?

Any help would be appreciated.

AndrewT