Iret = iim1.iimPlay("PP Attachment Ship-cr") <-this stage always errors then moves onto Attachment Submit below Iret = iim1.iimDisplay("Row# " + CStr(row)) Iret = iim1.iimSet("Enddate", Cells(row, 4).Value) Iret = iim1.iimSet("Startdate", Cells(row, 3).Value)
Iret = iim1.iimSet("Ponum", Cells(row, 2).Value) Iret = iim1.iimPlay("PP Orders Screen-cr") Iret = iim1.iimDisplay("Submitting Data from Excel") & vbNewLine & "Imacros is open", vbOKCancel, "SHIP TASK") = vbCancel Then If MsgBox("Before you click yes to enter data" & vbNewLine & "make sure PP is logged in and" _ Unfortunately I can't provide a link to the website as you need to be logged in to view (plus it's full of sensitive data).Īs mentioned above, many of the imacros have been created by previous employees, been cannibalised from reading up on what others have done or recording and working out how to do things for myself. The demo macros work but open a new instance of imacros and chrome browser each time they're ran. I think)Ĭurrent Chrome version is 1.54 (Official Build) (64-bit)Ĭurrent version of Windows 10 (version 21H2 - OS build 19044.1645) Again, this worked fine in IE.Ĭurrent version of iMacros for Chrome is v12.6 (64 bit) (Version build 10. We're also experiencing problems where lines of code don't seem to work anymore (like SET !MARKOBJECT NO seems to generate an error that the macro can't ignore even though SET !EVENTIGNORE YES is in place).
I thought I could try and re-record some of the imacros, to see if there was differences but the recorder only logs the first line (which is the url of the page I'm on) and none of the button clicks etc. With the switch to Chrome, we're finding every time a macro is ran from Excel, it will open a new instance of iMacros as well as a new Chrome browser despite both being open at the time and the best of my knowledge, the vba is correct (it doesn't have this behaviour in IE). We use it in conjunction with a lot of vba enabled spreadsheets and whilst we've been using IE, everything has been running fine without problems. I honestly thought it would just involve updating the odd line of code so imacros opened Chrome instead of IE but it doesn't appear that way anymore. We've upgraded to the Chrome version, have the Enterprise license etc. In the business I work for, we use iMacros to automate a lot of the day to day processes (mainly copy/pasting data into a website and submitting as well as page navigation however IE is about to be removed as support for it is being ended. Please forgive me, first time poster and pretty much everything I know about imacros and vba I've either inherited or had to teach myself so if any of the script is messy then I apologise!
0 kommentar(er)
