excel - Open a workbook while a code is running on another one -
my question title...
i have workbook opened macro running inside. when try open workbook during process loads forever.
question : if have macro running in workbook, there way open workbook ?
regarding code running, ensured using thisworkbook denomination wouldn't altered opening of other workbooks.
for information code :
option explicit private objie shdocvw.internetexplorer sub mysub() 'i)declaration of variables dim integer dim path string ' stores path 'ii)path platform path = "https://www.mywebsite.com" '1)navigate platform set objie = createobject("internetexplorer.application") objie.visible = true objie.navigate path loop while objie.readystate <> readystate_complete '3)check price start: loop while clng(objie.document.getelementsbyclassname("myclassname")(0).innertext) > 4200 , clng(objie.document.getelementsbyclassname("myclassname")(0).innertext) < 4500 '4) write down value in excel = + 1 thisworkbook.sheets("tabelle1").cells(7 + i, 4) = clng(objie.document.getelementsbyclassname("myclassname")(0).innertext) ' value thisworkbook.sheets("tabelle1").cells(7 + i, 3) = right(now, 8) ' time thisworkbook.sheets("tabelle1").cells(7 + i, 2) = date ' date application.wait + timeserial(0, 0, 10) goto start end sub
Comments
Post a Comment