Search found 78 matches

by nodochau
Tue Apr 28, 2020 10:08 am
Forum: Beginners
Topic: Show command help not working
Replies: 2
Views: 219

Re: Show command help not working

Thanks Marcus.
by nodochau
Wed Apr 22, 2020 6:26 pm
Forum: Beginners
Topic: Show command help not working
Replies: 2
Views: 219

Show command help not working

Hello All,
Does anybody get the problem like me today? the command help does not show in the bottom window when I write code anymore
Please help.

Thanks
by nodochau
Sat Apr 11, 2020 1:44 pm
Forum: Beginners
Topic: Resize Images
Replies: 15
Views: 478

Re: Resize Images

Thanks Dorian, If we create a VBA in excel then how do we save that file? just a regular excel file (xlsx)? or excel file with macro enable (xltm)? Or create a VBA then copy that into MS then just open the regular excel file? I tried your code but it does not work for me. I am sorry, maybe I missed ...
by nodochau
Fri Apr 10, 2020 6:42 pm
Forum: Beginners
Topic: Passing variable from MS to VBA in excel
Replies: 1
Views: 121

Passing variable from MS to VBA in excel

Hello All, I have multiples pictures and they need to be inserted to cells in excel. So I created a vba code within my sheet. Here is my code: Sub insert_pics() Dim ws As Worksheet Dim picture1 As Picture Dim i As Integer Set ws = ActiveSheet For i = 2 To 6 // 6 will be set by value by MS Set target...
by nodochau
Fri Apr 10, 2020 4:24 pm
Forum: Beginners
Topic: Resize Images
Replies: 15
Views: 478

Re: Resize Images

Support is quiet here at the moment so I was able to put some time into this for you. You should be able to use it as a template and to understand the methods I used. I created the VBA by recording a macro in Excel. Then copied the VBA into the script, with minor editing. As you can see, we can use...
by nodochau
Thu Apr 02, 2020 6:06 pm
Forum: General Discussion
Topic: How to use IEGetAllText or It not working
Replies: 1
Views: 285

How to use IEGetAllText or It not working

Hello All, I am trying to get all the text (html) in the web page but I get no luck.. Any ideas. Here is my code: XLOpen>C:\Users\1\Desktop\Jane2.xlsx,0,xlBook let>empty_cell= WaitWindowOpen>Excel* let>m=1 XLGetCell>xlBook,Sheet2,%m%,1,competitor While>competitor<>empty_cell Add>m,1 XLGetCell>xlBook...
by nodochau
Mon Mar 30, 2020 4:46 pm
Forum: Beginners
Topic: Resize Images
Replies: 15
Views: 478

Re: Resize Images

Thanks a lot Dorian,
I found out if you are in C:\users\pictures\imgs... then the IM works and if you create a folder within pictures folder like C:\users\pictures\resize_pic\imgs...then IM doesn't work. It is strange
But I made it worked now.
Again, I appreciate your help.
My project is done :)
by nodochau
Sun Mar 29, 2020 8:09 pm
Forum: Beginners
Topic: Resize Images
Replies: 15
Views: 478

Re: Resize Images

Something like this. It'll resize images using ImageMagick. Be careful, the script below will overwrite the files it finds. I'm just using this as a simple example of ImageMagick usage. IM is very powerful once you delve into it, and I'm sure there will be a way of resizing the images how you want....
by nodochau
Sun Mar 29, 2020 7:08 pm
Forum: Technical / Scripting
Topic: Is there a way to have Webrecorder/IE library save a image that is on a page
Replies: 10
Views: 999

Re: Is there a way to have Webrecorder/IE library save a image that is on a page

And Marcus, If I can find the urls of images then how can I save them as images instead of the urls? Thanks Use the command Marcus referred to, HTTPRequest . I know it but how? Cause I am new with this topic. Example I have this link of the image which I found from extracting text : https://m.media...
by nodochau
Sun Mar 29, 2020 6:59 pm
Forum: Technical / Scripting
Topic: Is there a way to have Webrecorder/IE library save a image that is on a page
Replies: 10
Views: 999

Re: Is there a way to have Webrecorder/IE library save a image that is on a page

Instead of doing that I would look at extracting the url from the source of the image and then retrieving it and saving to file with HTTPRequest. Should be able to do that with the IE/Edge/Chrome functions. And Marcus, If I can find the urls of images then how can I save them as images instead of t...
by nodochau
Sat Mar 28, 2020 6:53 pm
Forum: Technical / Scripting
Topic: Is there a way to have Webrecorder/IE library save a image that is on a page
Replies: 10
Views: 999

Re: Is there a way to have Webrecorder/IE library save a image that is on a page

Instead of doing that I would look at extracting the url from the source of the image and then retrieving it and saving to file with HTTPRequest. Should be able to do that with the IE/Edge/Chrome functions. And Marcus, If I can find the urls of images then how can I save them as images instead of t...
by nodochau
Fri Mar 27, 2020 11:28 pm
Forum: Technical / Scripting
Topic: Is there a way to have Webrecorder/IE library save a image that is on a page
Replies: 10
Views: 999

Re: Is there a way to have Webrecorder/IE library save a image that is on a page

Hi Marcus, That is my project for now. I want to save the product image of the seller on Amazon. I think the idea of find the position of the object then move mouse and do a save as. But can you give me an example? I am stuck with IEGetTagPos command. If you see the attached picture, I can find the ...
by nodochau
Fri Mar 27, 2020 2:03 am
Forum: Beginners
Topic: IEGetTags
Replies: 0
Views: 548

IEGetTags

I have another problem. I used IEGetTags to find all tags in the web page then will find the position of that tag by using IEGetTagPost. But I stuck now. IEGetTagPost>IE_Reference,Frame,Tagname,Attrib,Value,Xpos,Ypos. Questions: Tagname: Is it the tag that is return in array by using IEGetTags comma...
by nodochau
Wed Mar 25, 2020 5:47 pm
Forum: Beginners
Topic: Press CTRL and Home keys
Replies: 2
Views: 191

Press CTRL and Home keys

Hello ,
How to write a script to press CTRL and Home keys to move from whatever cell to A1 cell in Excel?
I tried press and send, Press and press, holdkey... and non of them work
Please help.
Sign up to our newsletter for free automation tips, tricks & discounts