Counters will just count up to specified Timer set point and return True to the TD_ON shape's Prop.OUT which called the Add-In. When Cop圜ells finishes at the 2nd time, given i4, the whole process stops. After Cop圜ells finishes, it shall return to Sub refreshsheet, next i, then i4 and run the whole process again. It will stop for 1 minute and then run sub Cop圜ells. In general, algorithm of "TD_ON" shape delays the time that the output is set to TRUE.ĭo you think that it is possible to do this with a special Add-In ? End user don't need to see the counting process, so there shouldn't be a user interface for counters in the add-in. For this macro, i intended to run Sub refreshsheet, first i3, and it comes to application.ontime. You can start counters again by changing output of "DI" shape to False and True After 2 seconds related counter will disappear from the Excel since it finished its job. Get up early on Tuesdays Sorry, I dont mean to be flippant, but if you have an IT department who tie your hands behind your back, then you cant be expected to be able to work efficiently. Please find attached sample Visio and Excel files for you to see what they do.Ĭhange the output of "DI" shape to True while Excel file is open, connectors between "DI" shape and TD_ON shapes will turn to red which means that their value is True and this value will be propogated to TD_ON shapes's Prop.IN1 value and for each TD_ON shape a counter will start in Excel file counting up to a time which is defined in Prop.TimeDelay of TD_ON blocks.Īfter the specified TimeDelay set point passed, Excel will make the Prop.OUT of related TD_ON shape True and connector on the right side of the TD_ON shape will turn to red. well unless anyone else has any bright ideas you have 2 options. Right now I use Application.OnTime method of Excel for real time calculations but an integrated solution in Visio would be better in terms of speed and reliability. I need your help to design a Visio add-in.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |