Can we translate Firefox iMacros Script to Excel VBA?

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

Forum statistics

Threads
1,226,834
Messages
6,193,215
Members
453,779
Latest member
C_Rules

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top