Search found 132 matches

by nodochau
Thu Jul 30, 2020 7:21 pm
Forum: Beginners
Topic: %CRLF% in Panel
Replies: 4
Views: 5287

%CRLF% in Panel

Hello,
I am creating a dialog with some Panels. When I setdialogproperty for panels, the %CRLF% does not work.
Do you have any idea?
Thanks s lot
by nodochau
Mon Jul 20, 2020 11:23 am
Forum: General Discussion
Topic: Set color for Button
Replies: 7
Views: 18108

Re: Set color for Button

Microsoft for some unknown reason did not give buttons color flexibility. However, panels are a lot like buttons and they can change colors. Here's a way to use a panel as a button. HighLight and UnHighLight are not technically needed to be able to execute the panel like a button, but I think they ...
by nodochau
Fri Jul 17, 2020 5:52 pm
Forum: General Discussion
Topic: Set color for Button
Replies: 7
Views: 18108

Re: Set color for Button

I tried to find where to set the color for it manually but I couldn't find it though. I could change Font size, color...
but I want to change the color for buttons.
Also tried the setdialogobjectcolor for MSbutton and it did not work :(
Please show me how to do that
by nodochau
Fri Jul 17, 2020 4:30 pm
Forum: General Discussion
Topic: Set color for Button
Replies: 7
Views: 18108

Set color for Button

Hello All,
Are we able to set color for buttons in dialog?
Thanks
by nodochau
Tue Jul 14, 2020 4:21 pm
Forum: Beginners
Topic: No matching IE instance found
Replies: 4
Views: 4848

Re: No matching IE instance found

Hi Dorian,
Yes my urls are different
the 1st url is http://xyz/Illuminator?service=Personalization
and the 2nd is https://xyz/Illuminator?service=...
You can see myurl and mynewurl.
And if I want to use IEGetURL to get the 2nd url after I log in, what IE_Reference should I use?

Thanks
by nodochau
Tue Jul 14, 2020 2:32 pm
Forum: Beginners
Topic: No matching IE instance found
Replies: 4
Views: 4848

No matching IE instance found

Hello, I create a piece of code to login to the website and doing things. I log in successfully and there is another button that I need to press so that I can get into the field that I want. I used IEGetTags command and I got the error: "No matching IE instance found". Tried to use IE Element Wizard...
by nodochau
Thu Jul 02, 2020 10:25 am
Forum: Technical / Scripting
Topic: HTTPRequest not working in Compiled version
Replies: 18
Views: 18204

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

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

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

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

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

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

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

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

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