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

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th...
Read more

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de...
Read more