Search found 19 matches

by Rick0825
Fri May 31, 2024 1:19 pm
Forum: Beginners
Topic: Invalid Variant Operation error on XLGet
Replies: 1
Views: 154

Invalid Variant Operation error on XLGet

I read some old posts about getting errors with XLGet function and was hoping new information was found about it. My spreadsheet was working fine and then without warning I get an error. I also tried adding the full path to the excel file XLGet>C: fullpath/Sample.xlsx,xlBook2 and that did not work e...
by Rick0825
Thu May 02, 2024 6:34 pm
Forum: Beginners
Topic: Pop up when image not found
Replies: 2
Views: 552

Re: Pop up when image not found

Found the issue. The image was not found. Have another question. I know you can direct one script to another, but can you ask it to go back to the original script on a specific line or spot? FindImagePos>%BMP_DIR%\image_2.bmp,SCREEN,1.0,1,XArr,YArr,NumFound,CCOEFF If>NumFound>0 MouseMove>XArr_0,YArr...
by Rick0825
Thu May 02, 2024 6:02 pm
Forum: Beginners
Topic: Pop up when image not found
Replies: 2
Views: 552

Pop up when image not found

So I have the following code: //Find and Left Click Center of FindImagePos>%BMP_DIR%\image_3.bmp,SCREEN,0.7,1,XArr,YArr,NumFound,CCOEFF If>NumFound>0 MouseMove>XArr_0,YArr_0 LClick ELSE MessageModal>Cant find it! Endif Why do I get the pop up screen saying unable to locate image instead of it moving...
by Rick0825
Wed May 17, 2023 7:07 pm
Forum: Beginners
Topic: Remote Desktop
Replies: 2
Views: 6405

Remote Desktop

It's been a long time since I used a remote desktop but the last time I did I used Team Viewer, and it was free! I tried it today and it appears to cost now. Not opposed to paying but is there a good internet free one? Or if you pay for yours, what is it called and how do you like it?
by Rick0825
Tue May 09, 2023 4:47 pm
Forum: Beginners
Topic: Getting tangled in loops
Replies: 11
Views: 9838

Re: Getting tangled in loops

Thanks so much for the help Dorian. I have become very familiar with the links you provided over the last few months. Ive learned so much. Now I feel like I just need to practice writing code. I also understand that I paid for the software and not a teacher, so if im stepping over that line then ple...
by Rick0825
Mon May 08, 2023 7:40 pm
Forum: Beginners
Topic: Getting tangled in loops
Replies: 11
Views: 9838

Re: Getting tangled in loops

Thank you Dorian I have not tried the software your suggesting, but ive tried others with not so good results. I'm just wanting to focus on MS code. Im loving it. The struggle is finding the right resources for direct questions that I have. Im used to Googling everything, but thats not been much hel...
by Rick0825
Mon May 08, 2023 7:20 pm
Forum: Beginners
Topic: Getting tangled in loops
Replies: 11
Views: 9838

Re: Getting tangled in loops

Is it possible then to use OCR Wizard in a loop to return multiple Strings? Im just curious about all the possibilities of MS. Im trying to learn more about moving data from 1 place to another. Am I getting close with this one? Its currently returning the text area of the last page only. Let>k=0 Lab...
by Rick0825
Mon May 08, 2023 6:44 pm
Forum: Beginners
Topic: Getting tangled in loops
Replies: 11
Views: 9838

Re: Getting tangled in loops

You are correct. I just put a 5 in there just to try and get different results. Ive changed the code so many times ive lost count. Would it be simpler to just use OCR Wizard to get the text as a string to move over to excel? But then how does it loop through and get all the rest. Example: Page 1 - W...
by Rick0825
Mon May 08, 2023 5:54 pm
Forum: Beginners
Topic: Getting tangled in loops
Replies: 11
Views: 9838

Getting tangled in loops

Many hours later.....Im trying to copy text from an 18 page PDF. The same text is spread throughout the PDF that im going after. My thought is to count image/text and then use OCR Wizard to copy and paste to Excel doc. An example text would be WSHP-1 on page 1 and WSHP-2 might be on page 3. Im using...
by Rick0825
Mon May 08, 2023 5:42 pm
Forum: Beginners
Topic: OCR Wizard problems
Replies: 6
Views: 8138

Re: OCR Wizard problems

Problem solved.
by Rick0825
Thu May 04, 2023 6:18 pm
Forum: Beginners
Topic: OCR Wizard problems
Replies: 6
Views: 8138

Re: OCR Wizard problems

Thanks for the quick reply Dorian. I looked in my recycle bin but not there. When you say reinstall you are talking about Macro Scheduler program itself? What will that do to all my current built macros and images?
by Rick0825
Thu May 04, 2023 5:56 pm
Forum: Beginners
Topic: OCR Wizard problems
Replies: 6
Views: 8138

OCR Wizard problems

Im getting the error "The Specified Module could not be found: OCR.DLL". when I run my code. A search showed this file does not exist anywhere on my computer. Is this a file I need to download? I also found my tessdata folder and it is empty.
by Rick0825
Sat Mar 18, 2023 4:57 pm
Forum: Beginners
Topic: Adding Rows in Excel
Replies: 1
Views: 6910

Adding Rows in Excel

So you can see in my code that im trying to add 14 rows inside a Table. The code works but it wont add 14 it only adds 1. I read up on loops but im just not their yet :( or am I going at this all wrong. My code above this gets me to the right sheet and cell C5. Thanks in advance! //Add 14 Rows Let>W...
by Rick0825
Sun Mar 12, 2023 9:37 pm
Forum: Beginners
Topic: Paste an OCR to Excel
Replies: 2
Views: 7262

Re: Paste an OCR to Excel

Works great. Such a learning curve, but im getting their. :D
Thanks again.
by Rick0825
Fri Mar 10, 2023 1:59 am
Forum: Beginners
Topic: Paste an OCR to Excel
Replies: 2
Views: 7262

Paste an OCR to Excel

I used the OCR Wizard to grab some text. Text capture would not recognize the text. It looks like the code is OCRArea>390,417,480,446,strText I then open an Excel file and need to paste to a cell. I was close to a solution by using MessageModal>strText I could do a copy and paste from there but I wo...
Sign up to our newsletter for free automation tips, tricks & discounts