Stack Overflow
Stack Overflow

Questions tagged [ontime]

54 questions
24
votes
8 answers

Getting around the Max String size in a vba function?

The max number of characters you can use in string in a vba function is 255. I am trying to run this function Var1= 1 Var2= 2 . . . Var256 =256 RunMacros= "'Tims_pet_Robot """ & Var1 & """ , """ & Var2 & """ , """ ... """ & Var256 """…
Ommit
  • 1,894
  • 5
  • 19
  • 26
11
votes
5 answers

How can I check for or cancel MULTIPLE pending application.ontime events in excel VBA?

I'm using the Application.Ontime event to pull a time field from a cell, and schedule a subroutine to run at that time. My Application.Ontime event runs on the Workbook_BeforeSave event. As such, if a user (changes the desired time + saves the…
goofology
  • 914
  • 2
  • 10
  • 21
11
votes
3 answers

Multiple Variable Arguments to Application.OnTime

I am working on a data acquisition frontend for Excel 2010. I can't figure out the syntax for passing multiple local variable arguments to Application.OnTime. http://markrowlinson.co.uk/articles.php?id=10 provides a good example for a single…
solemn
  • 119
  • 1
  • 1
  • 4
10
votes
8 answers

FogBugz compared to OnTime

Has anyone used both FogBugz and Axosoft's OnTime and care to offer an opinion? AxoSoft has a big feature comparison chart but I'm also interested in more subjective thoughts on things like ease of use and stability.
Mike Powell
  • 5,914
  • 4
  • 28
  • 28
7
votes
8 answers

What advantages does TFS 2010 have over Axosoft OnTime?

I am currently creating a business case for rolling out TFS 2010 as our source control and bug/release management tool. We currently use OnTime for our bug tracking software and subversion for our SCM. I was wondering what advantages TFS 2010 has…
Russell
  • 17,481
  • 23
  • 81
  • 125
6
votes
1 answer

VBA: How do I really stop Application.onTime()?

I have already read some questions/threads (e.g. this and this) about how to stop the VBA Application.OnTime procedure, but I just can't get it to stop! I am using it to pull some data every x seconds. I understand that when I call the OnTime()…
rex
  • 3,133
  • 6
  • 35
  • 62
5
votes
4 answers

Axosoft OnTime vs Countersoft Gemini

We are "upgrading" the systems at the company, moving from SourceSafe/BugNet/... (yeahy!) to some more serious systems. TFS is too expensive. We have come down to comparing OnTime vs Gemini. They both seem OK with an "OK" price-tag. We will…
Rolle
  • 297
  • 3
  • 5
5
votes
4 answers

OnTime for less than 1 second without becoming Unresponsive

I have a userform which runs a script every 100ms. The script handles images on the userform and is used to animate them, while the form continues to receive user input (mouse clicks and key presses). This continues until the userform is closed.…
Honey Lemon
  • 51
  • 1
  • 2
4
votes
1 answer

How to use Application.OnTime to call a macro at a set time everyday, without having to close workbook

I have written a macro that uses Application.OnTime that works if I manually execute the macro. I'm trying to automate this process so I don't have to write Application.OnTime in "This Workbook" or (Private Sub Workbook_Open() Most of you do this…
Shayne K
  • 69
  • 1
  • 2
  • 10
3
votes
1 answer

VBA ontime cancel scheduling

I have written a macro that runs at 15:30pm every workday when a workbook is first opened. When the workbook is closed it tries to open itself the next time the macro is scheduled to run. I have tried to turn the scheduler to false and am getting an…
user202684
3
votes
2 answers

Youtube API - equivalent of onTime

I am looking for a similar event in OnTime (jwplayer) in YouTube API. More precisely, with jwplayer, I used the following function that I would fit with the youtube player: //Fonction destinée à afficher des notes en fonction de la progression des…
Brice
  • 31
  • 1
3
votes
6 answers

OnTime Alternative?

I've recently begun working with a new software development firm. One of the things I would like to do is introduce a software management tool to collectively group the project development efforts within a single source. I've traditionally used…
Brian Scott
  • 9,221
  • 6
  • 47
  • 68
2
votes
0 answers

how to run two Sub simultaneously by Application.Ontime?

I have a sub as below: Function SumOf(Byval a As Integer, Byval b As Integer) Call CalHelper.Sum(a,b) Call CalHelper.Sum(a+1,b+1) SumOf = "OK" End Function And CalHelper Module contains: 'BEGIN Declare Private mWindowsTimerID As Long Private…
Davuz
  • 5,040
  • 13
  • 41
  • 61
2
votes
2 answers

Running Python functions at Certain Times of the Day

I've spent some significant time searching for something like this, but I think I'm not using the right search terms. Anyway, I have tasks that I want to do at certain times of the day, and these tasks are executable via a python-api. Is there a…
Tom Jones
  • 111
  • 5
2
votes
1 answer

VBA Excel Application OnTime after 1 minute activity

I have created a file and have a code, which after 1 minute regardless of where I am in the ActiveSheets goes to select the default cells that I indicated in the code. Please find my code below: This Workbook module: Option Explicit Private Sub…
Marco
  • 21
  • 2
1
2 3 4