I am lost. Can you help?

XCore · Post by **XCore** » Mon Jan 03, 2005 3:58 pm

I _think_ this program will do what I need.

I am attaching 2 screenshots of the program I need to automate. The first is the login screen. Password must be entered each time I login. The second is the update/download screen. The first radio button is the default and what I need but the date must be changed each day to update from the previous day. Then the software need to run and download all the new photos.

Target: "C:\Program Files\XMLSWeb\XMLSPhotos\XMLSPhoto.exe"

Any help would be greatly appreciated.

Bob Hansen · Post by **Bob Hansen** » Mon Jan 03, 2005 4:25 pm

Rough skeleton, untested, to get you started:

Tab to fields using Send as necessary
Login and enter password to continue
Wiat for next window to open
Convert todays date to yesterday's date
Use Send to fill in fields as necessary
Press ALT-D to download.
==================================

Code: Select all

WaitWindowOpen>Login*
SetFocus>Login*
Tab
Send>cmls
Tab
Send>yourid
Tab
Send>yourpassword
Tab
Press ENTER

WaitWindowOpen>Download*
SetFocus>Download*
GetDate>Today
Sub>Today,1
Send>%Today%
Press ALT
Send>D
Release ALT

XCore · Post by **XCore** » Mon Jan 03, 2005 4:44 pm

Thanks!

Now, can I pay someone here to do this?

Thanks

Bob Hansen · Post by **Bob Hansen** » Mon Jan 03, 2005 5:21 pm

I do this type of work when requested.

But you may be surprised to find that you could do it yourself. About 98% is done already for you. Have you tried what was submitted?

XCore · Post by **XCore** » Mon Jan 03, 2005 7:25 pm

Thanks for the reply.

Yes, I put it in the script editir and saved it but don't even have a clue what to do next. I'd be just as happy to pay for someone's prefessional experience than ask them to hold my hand for free.

Thanks.

Guest · Post by **Guest** » Mon Jan 03, 2005 11:46 pm

Let>MLSID=cmls
Let>UserID=yourid
Let>Password=BoBHansen

Run Program>C:\Program Files\XMLSWeb\XMLSPhotos\XMLSPhoto.exe
WaitWindowOpen>Login*
SetFocus>Login*
Tab
Send>%MLSID%
Tab
Send>%UserID%
Tab
Send>%Password%
Tab
Press ENTER

WaitWindowOpen>Download*
SetFocus>Download*
GetDate>Today
Sub>Today,1
Send>%Today%
Press ALT
Send>D
Release ALT

Have a try. Should work.
Thx to Bob who has created 99,99 % of the above script.

Guess Bob will be OK if you donate what you can afford to a charity org to help those who have survived the Tsunami in Asia. Do it!
Thx.

XCore · Post by **XCore** » Thu Jan 06, 2005 10:09 pm

Wow! This is a great forum of members. I have donated $50 to the Red Cross in the name of "The MJTNet Forum". Thanks.

The above code opens the program's first window but that's about it.

Thanks again.

Bob Hansen · Post by **Bob Hansen** » Fri Jan 07, 2005 2:34 am

Opens first window and that's all?

What happens if you single step throught the macro?
Can you create a log and provide a copy of it?

Is Download* the real name of the second window as seen by Macro Scheduler?
Can you try using the window handle instead?

Guest · Post by **Guest** » Sun Jan 30, 2005 2:12 pm

Hi, along the same lines, I want to log into a web page but can't make the macro do it. Would it be possible for anyone to point me in the right direction please?

VBSTART

Sub OpenPage(URL,Wait)

Dim IE
Set IE = CreateObject("InternetExplorer.Application")
IE.visible = 1
IE.navigate URL

do while IE.Busy and Wait
loop

End Sub

VBEND
Input>URL,Enter URL of Page to Visit:,www.retaileyes.co.uk/home/userlogin.php
VBRun>OpenPage,%URL%,1
Let>Username="My username"
Let>Password="My password"
SetFocus>Microsoft Internet Explorer*
Tab
Send>"My username"
Tab
Send>"My password"
Tab
Press ENTER

Guest · Post by **Guest** » Sun Jan 30, 2005 9:20 pm

Thanks everyone, I have had a reply to sort this out.