Search found 96 matches

by nodochau
Thu Jul 02, 2020 10:25 am
Forum: Technical / Scripting
Topic: HTTPRequest not working in Compiled version
Replies: 14
Views: 1331

Re: HTTPRequest not working in Compiled version

Marcus, If the "Copy Runtime DLLs" box is checked during compiling of the exe, is that enough? Do the files also need to be in the same folder as the exe at runtime? I thought I had done both earlier, but I didn't get the DLLs from the MS Folder, I had gotten them through the instructions in the li...
by nodochau
Mon Jun 29, 2020 10:05 am
Forum: Beginners
Topic: HTTPRequest does not work in .exe
Replies: 2
Views: 613

Re: HTTPRequest does not work in .exe

Hi Grovkillen,
I found the solution on this forum :)
Copied libeay32.dll, ssleay32.dll files into the folder where the exe file was.
It worked.
Thanks
by nodochau
Sun Jun 28, 2020 12:51 am
Forum: Beginners
Topic: HTTPRequest does not work in .exe
Replies: 2
Views: 613

HTTPRequest does not work in .exe

Hello All, I just try to test the httprequest to download a picture on amazon website. It worked on my laptop where the macro scheduler is installed but after I compile it and run the exe file on my desktop then it did not work. Do I need to do anything else beside compiling? Please help Here is my ...
by nodochau
Tue Apr 28, 2020 10:08 am
Forum: Beginners
Topic: Show command help not working
Replies: 2
Views: 876

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

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

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

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

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

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

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

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

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

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...
Sign up to our newsletter for free automation tips, tricks & discounts