Web page is ignored when Macro is .exe

Hints, tips and tricks for newbies

Moderators: Dorian (MJT support), JRL

Post Reply
DAY3
Newbie
Posts: 7
Joined: Mon Nov 28, 2011 5:46 pm
Location: Atlanta, Georgia USA

Web page is ignored when Macro is .exe

Post by DAY3 » Tue Mar 20, 2012 2:26 am

My macro works fine until I make it a .exe file, then it has problems opening my web pages. The remainder of the code appears to run on without the web page open at all.
Here is the first line of code down through the first part where the Web page is opened. Thie Web code parts were written by the Web Recorder.

Code: Select all

Let>IGNORESPACES=1

let>HarvestFileLoc={"D:\Clients\Home\HarvestFiles\"}

GoSub>Website1
GoSub>Website2
GoSub>Website3
GoSub>Website4

messagemodal>Complete

SRT>Website1
//Move the mouse cursor out of harm's way to avoid causing mouseover events to interrupt
MouseMove>0,0
Let>delay=1

//Open Excel File list of Counties
XLOpen>D:\Clients\Home\CountyList.xls,0,xlCounty

Wait>1

//Set timeout for ClickTag and FormFill to 10 seconds, increase if pages load more slowly
IE_SetTimeout>10,ie_res

IE_Create>0,IE[0]
IE_Navigate>%IE[0]%,http://website.net/website.aspx,ie_res

IE_WaitDocumentComplete>%IE[0]%,ie_res
Any advise or assistance would be greatly appreciated.
Last edited by DAY3 on Fri Mar 23, 2012 1:24 am, edited 1 time in total.

User avatar
JRL
Automation Wizard
Posts: 3526
Joined: Mon Jan 10, 2005 6:22 pm
Location: Iowa

Post by JRL » Tue Mar 20, 2012 3:03 am

Anything HERE help?

DAY3
Newbie
Posts: 7
Joined: Mon Nov 28, 2011 5:46 pm
Location: Atlanta, Georgia USA

Post by DAY3 » Tue Mar 20, 2012 3:49 am

Thanks for the quick response JRL.

I’m not using Vista, but Windows 2007 Home Premium SP1
When I right mouse click and “run as administratorâ€

User avatar
JRL
Automation Wizard
Posts: 3526
Joined: Mon Jan 10, 2005 6:22 pm
Location: Iowa

Post by JRL » Tue Mar 20, 2012 5:19 am

Both IEAuto.dll and IEAuto.ini are included in the same folder as the .exe macro is launched from.
I'm not an expert on this. I've only created a couple of scripts containing web recorder code, but I think the two files (IEAuto.dll and IEAuto.ini) need to be in a folder named "imports" at the location of the executable.

User avatar
Marcus Tettmar
Site Admin
Posts: 7395
Joined: Thu Sep 19, 2002 3:00 pm
Location: Dorset, UK
Contact:

Post by Marcus Tettmar » Tue Mar 20, 2012 10:44 am

JRL wrote:
Both IEAuto.dll and IEAuto.ini are included in the same folder as the .exe macro is launched from.
I'm not an expert on this. I've only created a couple of scripts containing web recorder code, but I think the two files (IEAuto.dll and IEAuto.ini) need to be in a folder named "imports" at the location of the executable.
Correct. Just copy the Imports folder from your Macro Scheduler program folder to the same location as your .exe.
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar

Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?

DAY3
Newbie
Posts: 7
Joined: Mon Nov 28, 2011 5:46 pm
Location: Atlanta, Georgia USA

Post by DAY3 » Tue Mar 20, 2012 9:48 pm

That seems to have done the trick!!

Thanks JRL and Marcus!

Post Reply
cron
Sign up to our newsletter for free automation tips, tricks & discounts