Search found 38 matches

by AndrewT
Sun May 03, 2020 2:52 pm
Forum: Technical / Scripting
Topic: Designing Radio Buttons
Replies: 3
Views: 2965

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

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
by AndrewT
Mon Apr 16, 2018 6:14 pm
Forum: Technical / Scripting
Topic: Running Excel Macro on CSV
Replies: 2
Views: 2208

Re: Running Excel Macro on CSV

I have tried the handle for both the CSV and the XLSB, but neither work.

If you use the ExecuteFile command instead of the XLOpen command, then the XLSB file is automatically loaded in the background.
by AndrewT
Fri Apr 13, 2018 7:45 pm
Forum: Technical / Scripting
Topic: Running Excel Macro on CSV
Replies: 2
Views: 2208

Running Excel Macro on CSV

So I have a MS script that creates a CSV file that it then opens in Excel with the ExecuteFile command. From there I want to run an Excel macro that is stored in the PERSONAL.XLSB project location. I have tried the XLRun command but nothing happens. I use the XLGet command first to get the handle of...
by AndrewT
Thu Jan 11, 2018 10:29 pm
Forum: Technical / Scripting
Topic: Access 2016
Replies: 1
Views: 2266

Access 2016

I am trying to connect to an Access 2016 database file that has the new extension of .accb. I downloaded the Microsoft Access Database Engine 2016 Redistributable and installed it on my computer. I also have Access 2016 installed on my computer. My connection string is: Provider=Microsoft.ACE.OLEDB....
by AndrewT
Wed Dec 27, 2017 9:33 pm
Forum: General Discussion
Topic: LibLoad and LibFree Best Practices
Replies: 2
Views: 3963

LibLoad and LibFree Best Practices

So in the MS Manual it says: Libraries loaded with LibLoad should always be freed with a call to LibFree after being used. I have a program that does a LibLoad>user32.... at the beginning of the program and then LibFunc>user32,FindWindowA.... several times within the program. My question is should I...
by AndrewT
Tue Dec 19, 2017 9:25 pm
Forum: Technical / Scripting
Topic: Save image with different names
Replies: 2
Views: 2230

Re: Save image with different names

Use a loop counter (ie. x=x+1) and then use this variable in your path name like:

Code: Select all

Let>x=0
Repeat>x
Let>x=x+1
Let>ImagePath=C:\Users\Matheus\Documents\Macro Scheduler 14\Firefox\dir(%x%).bmp
Rest of looping code
Until>x=end of loop condition
 
AndrewT
by AndrewT
Thu Nov 30, 2017 7:06 pm
Forum: Technical / Scripting
Topic: ArrayFind
Replies: 1
Views: 3438

ArrayFind

I am trying out the new ArrayFind function but not having any luck. I am trying to use it on the results of a DBQuery and the only result I get is an index of -1.

Can the ArrayFind function only be used on single dimension arrays? Any other tricks to this new function?

Thanks,
AndrewT
by AndrewT
Mon Dec 12, 2016 1:53 pm
Forum: Technical / Scripting
Topic: Send ALT not working
Replies: 2
Views: 2967

Re: Send ALT not working

Sorry, it was Press ALT that was not working for me.

In my haste to post this problem, I mis-read my code.

Andrew
by AndrewT
Fri Dec 09, 2016 4:11 pm
Forum: Technical / Scripting
Topic: Send ALT not working
Replies: 2
Views: 2967

Send ALT not working

**UPDATE** After upgrading to version 14.3.07, the problem is fixed!! :D :D I think something happened when I updated to version 14.3.05. I have a number of programs that use the Send>ALT command that have been working for over a year, and the old compiled versions still work. But since I updated to...
by AndrewT
Fri Feb 26, 2016 6:09 pm
Forum: Technical / Scripting
Topic: Clearing a StringGrid
Replies: 9
Views: 7510

Re: Clearing a StringGrid

OK, me again. :) As I think I have explained before, I use the StringGrid to display data from a SQLtoCSV query, then add/edit that data and then save this data back to a CSV file that I then use to later query in another program. The problem I am running into is that when I retrieve the data from t...
by AndrewT
Wed Feb 17, 2016 11:19 pm
Forum: Technical / Scripting
Topic: Clearing a StringGrid
Replies: 9
Views: 7510

Re: Clearing a StringGrid

And that is why I ask! It would have taken me forever to figure it out and my solution won't have been that simple.

Thank you,
Andrew
by AndrewT
Wed Feb 17, 2016 8:37 pm
Forum: Technical / Scripting
Topic: Clearing a StringGrid
Replies: 9
Views: 7510

Re: Clearing a StringGrid

So I am still working with this program and the StringGrid for data entry. Like JRL alluded to earlier, the I had to make the whole grid editable, which may or may not be OK for deployment. If I could "Lock" certain columns, that would be nice. I am thinking I can overwrite the edited data with the ...
by AndrewT
Tue Feb 16, 2016 4:47 pm
Forum: Technical / Scripting
Topic: Script Control Message Box
Replies: 1
Views: 2345

Script Control Message Box

I have a MS program that uses the SQLToCSV VB script. The SQL query is on a large table so it takes a bit longer, but almost immediately a message box comes up that is labeled Script Control. The message says that the script is taking longer than expected to execute and gives the use the option to e...
cron
Sign up to our newsletter for free automation tips, tricks & discounts