Hints, tips and tricks for newbies
Moderators: Dorian (MJT support), JRL
-
DAY3
- Newbie
- Posts: 7
- Joined: Mon Nov 28, 2011 5:46 pm
- Location: Atlanta, Georgia USA
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.
-
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
-
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â€
-
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.
-
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.
-
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!