Calling iMacros From Excel

Support for iMacros. The iMacros software is the unique solution for automating every activity inside a web browser, for data extraction and web testing.
Forum rules
Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the Google search box (at the top of each forum page) to see if a similar problem or question has already been addressed. This will search the entire contents of the forums as well as the iMacros Wiki.
3. We can respond much faster to your posts if you include the following information:


Answering your own posts (e.g. attempting to "bump" your topic) drops your topic from the list of unanswered threads, so it may actually receive less views.
Post Reply
Posts: 1
Joined: Fri Jun 30, 2017 12:11 pm

Calling iMacros From Excel

Post by deluxe247 » Fri Jun 30, 2017 12:42 pm

I have an Excel spreadsheet with a web address in cell A1. I have a copy of the scripting version of the iMacros browser. I'm trying to open the iMacros browser from Excel and then have the iMacros browser navigate to the web address in cell A1 of my Excel spreadsheet.

I was able to do this with my old laptop. When I tried this with my new laptop, the iMacros browser opens but doesn't navigate to the webaddress in cell A1.


Here's the code I've been using:

Sub Test()

Dim iim1, iret, row, totalrows

Set iim1 = CreateObject("imacros")
iret = iim1.iimInit("", False)
iret = iim1.iimDisplay("Submitting Data from Excel")

'Go To A1
row = 1
'Set the variable
iret = iim1.iimSet("-var_letterofalphabet", Cells(1, 1).Value)
'Set the display
iret = iim1.iimDisplay("Row# " + CStr(row))
'Run the macro
iret = iim1.iimPlay("#Current6")
Cells(row, 7).Value = Replace(iim1.iimGetLastExtract(), "[EXTRACT]", "")

End Sub
Post Reply