Search found 12 matches

by silvanpierce
26 Apr 2024, 09:37
Forum: Ask for Help (v1)
Topic: Double IF statement always flags True
Replies: 4
Views: 394

Re: Double IF statement always flags True

mikeyww wrote:
26 Apr 2024, 08:55

arr := [1, 5]
@mikeyww does it matter in this case if my array items have quotes around them? i am checking to see if a 6 digit string (%77%) exists in my array of ~30, 6 digit strings
by silvanpierce
26 Apr 2024, 06:59
Forum: Ask for Help (v1)
Topic: Double IF statement always flags True
Replies: 4
Views: 394

Double IF statement always flags True

i am trying to use a series of if statements to check if variables exist & match. the problem is that the 2nd statement is always flagging true; causing the last portion of the script to trigger when it shouldn't. in the code below, the loop will end up flagging 2 Vars as MW or OS. the first loop sh...
by silvanpierce
06 Oct 2023, 09:20
Forum: Ask for Help (v1)
Topic: Help with Script (big ask, i know)
Replies: 0
Views: 169

Help with Script (big ask, i know)

i am pasting my entire script below, as i have not been able to pinpoint the spot that is messing it up. the problems: -my "numpadadd" and "numpadsub" hotkeys are not being interpreted as hotkeys, but insead it is just typing "+" or "-" into the field that is active. - for some reason i have to pres...
by silvanpierce
19 Jan 2023, 17:14
Forum: Ask for Help (v1)
Topic: Pasting into Excel via COM
Replies: 3
Views: 342

Pasting into Excel via COM

i am trying to use COM to paste a spread of data into excel, as you can see; the data is 'spread out' and does not paste correctly if done via COM. if i copy and use control + V it pastes how i would like... with each cell housing one of the numbers/blank spaces. when i use COM (to grab the data/pas...
by silvanpierce
11 Jan 2023, 10:52
Forum: Ask for Help (v1)
Topic: finding the correct COM Interface name for IBM AS400
Replies: 1
Views: 249

finding the correct COM Interface name for IBM AS400

I use a 5250 Emulator to access our AS400 system, and i am certain that I can use COM to control it rather than "send" commands. IBM has content on their support documents that mention a COM interface and digging though my RegEdit; I found the name that I thought it should be, but Alas... no luck. "...
by silvanpierce
24 Oct 2022, 08:33
Forum: Ask for Help (v1)
Topic: Outlook Search non-standard (or all) folders
Replies: 0
Views: 177

Outlook Search non-standard (or all) folders

I currently have a working script to search my Inbox, and deleted folders. I would like to add a folder for it to search, but it is not a default folder. the folder name is "RFQs". Alternatively, if i could have it search ALL folders, that would also be a nice option, but I think I would want it to ...
by silvanpierce
11 Oct 2022, 20:11
Forum: Ask for Help (v1)
Topic: Cant insert excel formula correctly
Replies: 1
Views: 164

Cant insert excel formula correctly

3:: xl := ComObjActive("Excel.Application") comobjerror(false) xl.range("A2").value := "=IF(3:3=0, """", 3:3)" return this is how i am trying to insert a formula into a cell in excel. for some reason, it pastes random "@" symbols in with it? specifically like this - =@IF(@3:3=0, """", 3:3) i cannot...
by silvanpierce
05 Aug 2022, 09:15
Forum: Ask for Help (v1)
Topic: Script Consistency Help
Replies: 0
Views: 350

Script Consistency Help

hello, everyone below is my messy script that does something very simple - copy numbers/info in a IBM app > paste to excel > use that excel date to display other data in a GUI. I would say it has a ~80% success rate, with the main issue being that the very first bit of data it copies. It makes it to...
by silvanpierce
06 Jul 2022, 08:28
Forum: Ask for Help (v1)
Topic: Pasting to specific Excel sheet Topic is solved
Replies: 3
Views: 472

Re: Pasting to specific Excel sheet Topic is solved

Where you would have ActiveSheet , use Worksheets("Sheet 2") instead (assuming it really has a space between "Sheet" and "2" like you showed, which isn't Excel's default naming). It's more likely that it's actually "Sheet2". you have no idea how annoyed I am at how simple that was.. I must have tri...
by silvanpierce
06 Jul 2022, 07:43
Forum: Ask for Help (v1)
Topic: Pasting to specific Excel sheet Topic is solved
Replies: 3
Views: 472

Pasting to specific Excel sheet Topic is solved

hello, all I am trying to see if it is possible to paste data into a specific cell on a specific excel sheet . so far I have figured out getting it into my active excel, on whatever sheet is active; but if it would be possible to paste something into "Sheet 2" while I'm sitting in "Sheet 1"' that'd ...
by silvanpierce
08 Apr 2022, 08:10
Forum: Ask for Help (v1)
Topic: traverse window in segments Topic is solved
Replies: 1
Views: 183

traverse window in segments Topic is solved

I am trying to see if using something like

Code: Select all

Area1(),Area2(),...
is a reasonable solution to travel across the boxes pictured.
ideally I would use my arrow keys with a mousemove to travels from box to box. is there a better way i should be looking into for this?


image.png
image.png (79.7 KiB) Viewed 183 times
by silvanpierce
23 Feb 2022, 12:50
Forum: Ask for Help (v1)
Topic: Buttons activating Functions
Replies: 1
Views: 475

Buttons activating Functions

I have spent way too long working on a program to help at work. I am past my own skill level on this, and cannot figure out the last thing i need to make it work :cry: What I have : a GUI with a few Buttons, each linked to a function(s) the problem I have : when the GUI/Script is started, all functi...

Go to advanced search