Search found 96 matches

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

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

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

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.
by nodochau
Wed Mar 25, 2020 4:40 pm
Forum: Beginners
Topic: Resize Images
Replies: 15
Views: 2126

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
Wed Mar 25, 2020 4:34 pm
Forum: Beginners
Topic: Resize Images
Replies: 15
Views: 2126

Re: Resize Images

Thank you Dorian.
by nodochau
Wed Mar 25, 2020 3:35 pm
Forum: Beginners
Topic: Resize Images
Replies: 15
Views: 2126

Resize Images

Hello,
I have some pictures those need to be resized so that they can be inserted into a spreadsheet (with a size: Height=0.28" Width=0.7") . So I am wondering that are we able to do the task with MS?
Any help would be greatly appreciated!

Thanks
by nodochau
Wed Mar 25, 2020 11:08 am
Forum: General Discussion
Topic: Anyone else experiencing this...?
Replies: 3
Views: 962

Re: Anyone else experiencing this...?

Marcus Tettmar wrote:
Tue Mar 24, 2020 8:20 am
In the editor menu click on the Debug menu and uncheck Save on Run/Debug.
Thanks Marcus. Just know it..
by nodochau
Fri Mar 13, 2020 2:01 pm
Forum: Beginners
Topic: Gathering info on amazon
Replies: 3
Views: 2803

Re: Gathering info on amazon

I'd start off by seeing if you can extract the elements you're looking for with the Find IE Element Wizard . Maybe also see if IEGetAllText will extract what you're looking for, which can then be parsed. Those are starting points, but experimentation is the key. You'd probably need to start with a ...
by nodochau
Tue Mar 10, 2020 2:22 pm
Forum: Beginners
Topic: Gathering info on amazon
Replies: 3
Views: 2803

Gathering info on amazon

Hello All, I am new in gathering info on website. My goal is gather the info from our competitors on amazon. I can use macro recorder to create a program but I am not a fan of move mouse command. Could you help me where can I start? Let say I want to get all info such as: price, customer ranking val...
by nodochau
Mon Mar 09, 2020 12:34 pm
Forum: Technical / Scripting
Topic: Creating a line graph from script created data
Replies: 14
Views: 8563

Re:

Hi JRL, This is what I am looking for. I have an data excel file and data will be within +tolerance and -tolerance. Can you show me how to create a graph in dialog? My data looks like this: +TOL=0.005 -TOL=-0.005 data in one column: 1.004, 0.996, 1.003..... So the nominal dimension is 1 and the grap...
by nodochau
Thu Feb 13, 2020 8:08 pm
Forum: Beginners
Topic: XLSheetToArray
Replies: 13
Views: 1519

Re: XLSheetToArray

Just wanted to give you an update. I copy some data from the Sheet that I get the issue with and paste them into the new one so that I have new (created with brand new excel sheet) and old (copied from the issue sheet) data in my new sheet. Code works OK with new data and does not work with old dat...
by nodochau
Thu Feb 13, 2020 3:26 pm
Forum: Beginners
Topic: XLSheetToArray
Replies: 13
Views: 1519

Re: XLSheetToArray

Grovkillen wrote:
Thu Feb 13, 2020 3:18 pm
If you read the manual you'll see that the XL commands are XLS compatible only.
That is the reason why I save it as a xls format.
by nodochau
Thu Feb 13, 2020 3:25 pm
Forum: Beginners
Topic: XLSheetToArray
Replies: 13
Views: 1519

Re: XLSheetToArray

Just wanted to give you an update. I copy some data from the Sheet that I get the issue with and paste them into the new one so that I have new (created with brand new excel sheet) and old (copied from the issue sheet) data in my new sheet. Code works OK with new data and does not work with old data.
by nodochau
Thu Feb 13, 2020 3:12 pm
Forum: Beginners
Topic: XLSheetToArray
Replies: 13
Views: 1519

Re: XLSheetToArray

It seems like there are some problems with my spreadsheet. I don't know why. Just created a new one and code worked find. The file that I get the issue with was a xlsx file and I saved it as xls to use the command. Will it be a problem?? Any ideas? Or people at my work are using some unknown format ...
by nodochau
Thu Feb 13, 2020 11:37 am
Forum: Beginners
Topic: XLSheetToArray
Replies: 13
Views: 1519

Re: XLSheetToArray

Yes I did. Did a debug line by line and it did not stop at the customer Mani. Any spaces, strings..related??
Sign up to our newsletter for free automation tips, tricks & discounts