excel - Call Application.OnTime with fully qualified path to sub? -

-

i have spreadsheet implemented timer in automatically update formula every 10 seconds. working great until open spreadsheet. assumption was still trying run timer() on wrong sheet. so, tried switching absolute calls. here full code:

dim timeractive boolean sub starttimer()     start_timer end sub private sub start_timer()     timeractive = true     application.ontime now() + timevalue("00:00:10"), "timetrack.xlsm!tracker.timer" end sub sub stop_timer()     timeractive = false end sub sub timer()     dim tracker worksheet     set tracker = workbooks("timetrack.xlsm").sheets("tracker")     tracker.range("o1").value = "timer stopped"     'on error resume next     if timeractive         tracker.range("o2").value = time         application.ontime now() + timevalue("00:00:10"), "timetrack.xlsm!tracker.timer"         tracker.range("n:n").calculate     end if     tracker.range("o1").value = "" end sub

specifically, i'm getting error on application.ontime line:

cannot run macro ''s:\onedrive...!docs\timetrack.xlsm'!tracker.timer'. macro may not available in workbook or macros may disabled.

the path shows in error correct. wrong? what's weird seems run in starttimer() sub without issue.

to refer procedure in worksheet, need use worksheet.codename , not worksheet.name :

application.ontime now() + timevalue("00:00:10"), thisworkbook.name & "!" & me.codename & ".timer"

Comments

Post a Comment

Popular posts from this blog

html - Styling progress bar with inline style -

-
i trying set progress bar color red using inline style. need in way because have access <body> part of document. style need apply: progress { color: red } progress::-moz-progress-bar { background: red;} progress::-webkit-progress-value { background: red; } progress[aria-valuenow]:before { background: red; } i tried <progress style="background: red;"> incorrect effect, progress bar color turns blue red background. guide right direction desired style? thank in advance. here live example: https://jsfiddle.net/z36d3f6l/
Read more

java - Oracle Sql developer error: could not install some modules -

-
i have downloaded fresh copy of sqldeveloper ( sqldeveloper-4.1.3.20.78-no-jre ) oracle website. when unzip , lauch gui, keep getting following error message: warning - not install modules: dynamic module config - no module providing capability org.netbeans.netbinox found. my system: windows 7 32 bit hp probook. jdk 1.6 , 1.7, 1.8 available in java/jdk subdirectory. netbeans 8.0.2 installed finally got way out after dirty hours. extracted sqldeveloper zip in nested directory. i.e: e://a/b/c/sqldeveloper. starting sqldeveloper gui above directory threw erros. solution: go in c:\users**username**\appdata\roaming : delete sql developer , sqldeveloper folders extract sql developer zip in new non nested directory. i.e: e:// start , should work now reference: https://community.oracle.com/thread/3870680?start=0&tstart=0
Read more

How to use autoclose brackets in Jupyter notebook? -

-
this may sound silly question, how make use of autoclose brackets in jupyter notebook? example, when type print( jupyter notebook auto-closes brakets print() and places cursor inside. type argument, say print(1 + 1) now cursor between second 1 , right bracket ) . key navigate right of ) ? of course can press end or → or ) achieve this, not seem save time, purpose of brackets autoclose suppose? thanks in advance.
Read more