Search found 16 matches

by Rick0825
Wed May 17, 2023 7:07 pm
Forum: Beginners
Topic: Remote Desktop
Replies: 2
Views: 5113

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

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

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

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

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

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

Re: OCR Wizard problems

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

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

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

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

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

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...
by Rick0825
Sun Mar 05, 2023 9:57 pm
Forum: Technical / Scripting
Topic: My Excel Functions are not working
Replies: 6
Views: 2056

Re: My Excel Functions are not working

XLGet worked. My final code ended up being:

Code: Select all

XLGet>Book1,xlBook
Wait>1.0
XLSelectRange>xlBook,Sheet1,B3:B16
Thanks for your patients. :D
by Rick0825
Sun Mar 05, 2023 7:36 pm
Forum: Technical / Scripting
Topic: My Excel Functions are not working
Replies: 6
Views: 2056

Re: My Excel Functions are not working

Ok I got it to work almost. I now understand what you mean when you say: "Open returns a handle in XLBookHandle which should be used to reference the workbook in other XL commands." But what if the excel file has been opened already by another program and it has NOT been saved to my computer. Does t...
by Rick0825
Sun Mar 05, 2023 7:05 pm
Forum: Technical / Scripting
Topic: My Excel Functions are not working
Replies: 6
Views: 2056

Re: My Excel Functions are not working

Still getting the same error. I took out the "XLOpen" line because the file is already open. Using the debug tool the error happens on the XLSelectRange line. I also tried saving the Book1 file to my desktop and using the XLOpen with full file location but it made no difference. I know I have to be ...
cron
Sign up to our newsletter for free automation tips, tricks & discounts