@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
Search found 12 matches
- 26 Apr 2024, 09:37
- Forum: Ask for Help (v1)
- Topic: Double IF statement always flags True
- Replies: 4
- Views: 394
- 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...
- 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...
- 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...
- 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. "...
- 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 ...
- 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...
- 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...
- 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...
- 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 ...
- 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
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?
Code: Select all
Area1(),Area2(),...
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?
- 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...