raghuram.star
Board Regular
- Joined
- Sep 5, 2012
- Messages
- 102
Hi MrExcel.
I want to know if we can translate Firefox iMacros Script to Excel VBA Script so that I can execute it directly from Excel without the need of Firefox. (Because Firefox is delisted in our company, which forced me to do the activities manually in Internet Explorer)
I have little knowledge in updating/getting information from Internet Explorer using VBA.
Any help is much appreciated,
Thanks in advance.
RR
I want to know if we can translate Firefox iMacros Script to Excel VBA Script so that I can execute it directly from Excel without the need of Firefox. (Because Firefox is delisted in our company, which forced me to do the activities manually in Internet Explorer)
I have little knowledge in updating/getting information from Internet Explorer using VBA.
Any help is much appreciated,
Thanks in advance.
RR
Code:
VERSION BUILD=8920312 RECORDER=FX
TAB T=1
TAB CLOSEALLOTHERS
URL GOTO=http://autowest.MyCorp.root.local/autotime/UseSSL/LoginPage.asp
TAB OPEN
URL GOTO=http://autowest.MyCorp.root.local/autotime/UseSSL/LoginPage.asp
SET !ENCRYPTION NO
TAG POS=1 TYPE=INPUT:PASSWORD FORM=NAME:LoginForm ATTR=NAME:txtPIN CONTENT=MyPassword
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:LoginForm ATTR=NAME:txtEmployeeNum CONTENT=123456789
TAG POS=1 TYPE=INPUT:SUBMIT FORM=NAME:LoginForm ATTR=NAME:btnLogin
TAB T=2
FRAME NAME="frameMainMenu"
TAG POS=1 TYPE=SPAN ATTR=TXT:Supervisor
TAG POS=1 TYPE=SPAN ATTR=ID:1449Text
FRAME NAME="frameMainForm"
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:EIForm ATTR=NAME:txtEntityNum CONTENT=123456
TAG POS=1 TYPE=SELECT FORM=NAME:EIForm ATTR=NAME:txtPlantID CONTENT=%NF_KLM_IND
TAG POS=1 TYPE=SELECT FORM=NAME:EIForm ATTR=NAME:txtEntityType CONTENT=%O
TAG POS=1 TYPE=NOBR ATTR=TXT:Find
TAG POS=1 TYPE=NOBR ATTR=TXT:Modify
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:EIForm ATTR=ID:StartDate__day CONTENT=09
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:EIForm ATTR=ID:StartDate__month CONTENT=12
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:EIForm ATTR=ID:StartDate__year CONTENT=2014
TAG POS=1 TYPE=IMG ATTR=SRC:http://autowest.MyCorp.root.local/autotime/images/save.gif
TAG POS=1 TYPE=IMG ATTR=SRC:http://autowest.MyCorp.root.local/autotime/images/details.gif
'Below 6 line are repetitive in nature, could go long as 1000+ times - this is real pain
TAG POS=1 TYPE=INPUT:RADIO FORM=NAME:EIForm ATTR=NAME:radioSelRow
TAG POS=1 TYPE=NOBR ATTR=TXT:Modify
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:EIForm ATTR=ID:OperStartDate__day CONTENT=09
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:EIForm ATTR=ID:OperStartDate__month CONTENT=12
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:EIForm ATTR=ID:OperStartDate__year CONTENT=2014
TAG POS=1 TYPE=NOBR ATTR=TXT:Save
TAG POS=2 TYPE=INPUT:RADIO FORM=NAME:EIForm ATTR=NAME:radioSelRow
TAG POS=1 TYPE=NOBR ATTR=TXT:Modify
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:EIForm ATTR=ID:OperStartDate__day CONTENT=09
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:EIForm ATTR=ID:OperStartDate__month CONTENT=12
TAG POS=1 TYPE=INPUT:TEXT FORM=NAME:EIForm ATTR=ID:OperStartDate__year CONTENT=2014
TAG POS=1 TYPE=NOBR ATTR=TXT:Save