Search found 38 matches
- 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...
- Thu Aug 16, 2018 1:22 pm
- Forum: Technical / Scripting
- Topic: Setting variable to an Extended ASCII Character
- Replies: 3
- Views: 2730
- 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?
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
Code: Select all
Let>fnd={Ascii(150)}
Code: Select all
If>{%Target% = Ascii(150)}
Any help would be appreciated.
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.
If you use the ExecuteFile command instead of the XLOpen command, then the XLSB file is automatically loaded in the background.
- 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...
- 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....
- 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...
- 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:
AndrewT
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
- 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
Can the ArrayFind function only be used on single dimension arrays? Any other tricks to this new function?
Thanks,
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
In my haste to post this problem, I mis-read my code.
Andrew
- 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...
- 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...
- 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
Thank you,
Andrew
- 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 ...
- 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...