Search found 16 matches
- Wed May 17, 2023 7:07 pm
- Forum: Beginners
- Topic: Remote Desktop
- Replies: 2
- Views: 5124
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?
- Tue May 09, 2023 4:47 pm
- Forum: Beginners
- Topic: Getting tangled in loops
- Replies: 11
- Views: 8293
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...
- Mon May 08, 2023 7:40 pm
- Forum: Beginners
- Topic: Getting tangled in loops
- Replies: 11
- Views: 8293
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...
- Mon May 08, 2023 7:20 pm
- Forum: Beginners
- Topic: Getting tangled in loops
- Replies: 11
- Views: 8293
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...
- Mon May 08, 2023 6:44 pm
- Forum: Beginners
- Topic: Getting tangled in loops
- Replies: 11
- Views: 8293
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...
- Mon May 08, 2023 5:54 pm
- Forum: Beginners
- Topic: Getting tangled in loops
- Replies: 11
- Views: 8293
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...
- Mon May 08, 2023 5:42 pm
- Forum: Beginners
- Topic: OCR Wizard problems
- Replies: 6
- Views: 6713
Re: OCR Wizard problems
Problem solved.
- Thu May 04, 2023 6:18 pm
- Forum: Beginners
- Topic: OCR Wizard problems
- Replies: 6
- Views: 6713
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?
- Thu May 04, 2023 5:56 pm
- Forum: Beginners
- Topic: OCR Wizard problems
- Replies: 6
- Views: 6713
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.
- Sat Mar 18, 2023 4:57 pm
- Forum: Beginners
- Topic: Adding Rows in Excel
- Replies: 1
- Views: 5617
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...
- Sun Mar 12, 2023 9:37 pm
- Forum: Beginners
- Topic: Paste an OCR to Excel
- Replies: 2
- Views: 5949
Re: Paste an OCR to Excel
Works great. Such a learning curve, but im getting their.
Thanks again.
Thanks again.
- Fri Mar 10, 2023 1:59 am
- Forum: Beginners
- Topic: Paste an OCR to Excel
- Replies: 2
- Views: 5949
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...
- 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:
Thanks for your patients.
Code: Select all
XLGet>Book1,xlBook
Wait>1.0
XLSelectRange>xlBook,Sheet1,B3:B16
- 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...
- 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 ...