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 search box (at the top of each forum page) to see if a similar problem or question has already been addressed.
3. Try searching the iMacros Wiki - it contains the complete iMacros reference as well as plenty of samples and tutorials.
4. We can respond much faster to your posts if you include the following information:CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST
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