Macro Scheduler Forums

Rick0825

Only took me about 8 hrs but I figured it out. :D Let>kCount=4 Let>row=0 Let>k=0 Repeat>row Repeat>k Let>k=k+1 XLGetSelectedCell>xlBook,data_%k%,intRow,intCol Let>stored_%k%=data_%k% Wait>0.5 Press Right Wait>0.5 Until>k=%kCount% Press Down Wait>0.5 Press Left * 4 Let>kCount=kCount+4 Let>row=row+1 U...

Rick0825

Thanks Dorian! Now I am on to looping back to get more data from my spreadsheet. Does this look like it would work? Let row=0 Repeat>row Let>row=row+1 Let>k=0 Repeat>k Let>k=k+1 XLGetSelectedCell>xlBook,data_%k%,intRow,intCol Let>stored_%k%=data_%k% Wait>0.5 Press Right Wait>0.5 Until>k=4 Wait>0.5 P...

Rick0825

Can someone help with getting my code right. I think im close but need a nudge. I have a spreadsheet that I am trying to find a list of words using the find feature in excel. When I find the word, the number I need is 1 cell below it. The part I need help with is saving the data or number im after t...

Rick0825

#2 = Very clever. Thank you!

Rick0825

Thanks, but im not sure this was helpful? LabelToVar>LabelName,VariableName[,WantLineBreaks,IgnoreVariables,EndToken https://www.mjtnet.com/manuals/b/v15/in ... ntext=3980 The line breaks & ignore variables default to 0 if that's what you were trying to point out? There were 2 issues with my code. 1...

Rick0825

Another question then. What if I wanted to change the text to a variable inside the HTML table as shown here. <body> <table> <tr> <th>%Alarm%</th> <th>%Status%</th> </tr> <tr> <td>%Alarm 1%</td> <td>%Active%</td> </tr> <tr> <td>%Alarm 2%</td> <td>%Inactive%</td> </tr> </table> </body> I created the ...

Rick0825

Thank you Grovkillen. I did not see your reply until after my post but im glad I was on the right track.

Rick0825

I found a solution but have no idea how or why it works, but maybe it can help others. Let>SMTP_HTMLBODY=1 LabelToVar>MyLabel,body IncludeFromVar>body /* MyLabel: <html> <head> <style> table { font-family: Arial, sans-serif; border-collapse: collapse; width: 100%; font-size: 14px; } td, th { border:...

Rick0825

I have an email that im trying to add HTML code to the body of the email. It works great when all the code is on the same line but..... Its WAY to much on 1 line. I used word wrap but its still to messy. Does it have something to do with creating the body in a variable? Is there any other way? Let>S...

Rick0825

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...

Rick0825

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...

Rick0825

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...

Rick0825

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?

Rick0825

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...

Rick0825

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...

Search found 28 matches

Re: Saving multiple variables in a loop

Re: Saving multiple variables in a loop

Saving multiple variables in a loop

Re: HTML code on multiple lines

Re: HTML code on multiple lines

Re: HTML code on multiple lines

Re: HTML code on multiple lines

Re: HTML code on multiple lines

HTML code on multiple lines

Invalid Variant Operation error on XLGet

Re: Pop up when image not found

Pop up when image not found

Remote Desktop

Re: Getting tangled in loops

Re: Getting tangled in loops