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.

Moderators: Community Moderators, iMacros Moderators

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:

CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST

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.

Calling iMacros From Excel

by deluxe247 on Fri Jun 30, 2017 5:42 am

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.

Thoughts?

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
deluxe247
 
Posts: 1
Joined: Fri Jun 30, 2017 5:11 am

Return to General Support & Discussions

Who is online

Users browsing this forum: Google [Bot] and 12 guests

-->