now i can sleep peacefully. you have made my night. i was searching for this for 2 days. Finally i found the solution of the error while stopping this application.ontime code. thank you ❤️
Thanks for the great ideas which extend our VBA skills so well. Here is a thought or two, I find it convenient and less confusing to post comments at the end of code. That eliminates the confusion while determining if comments precede or follow the code and saves space by reducing lines count, especially as maintenance coders use different conventions. Spacing is rarely needed and can be better reserved for logical breaks. Also, it is easier to ignore if no longer needed. With just Tab and Quote keystroke(s) your comments are easily aligned and lengthy lines can be continued with the same keys. Another freebie: Copy the complete Sub/Function title line to the end of the End Sub/Function line, press Tab, Quote, Ctrl-v (paste) yielding "End Sub 'Sub macro_timer()" -- which is helpful when spinning through modules with many Sub's, Function's, etc. since you see where you are without needing to page-up, and will see the full argument structure for the code above. Together giving: Sub macro_timer() ' TeachExcel.com interval = Now + TimeValue("00:00:05") ' Set your interval here Application.OnTime interval, "my_macro" ' Tells Excel when to next run the macro. End Sub 'Sub macro_timer()
I love this one! Useful in my multiple macro set up. Is there a way that excel can send a command using ssh, without a need of another program like putty?
Thanks) Your question is a pretty big one and the solution depends on a lot of factors, you can ask in our forum on teachexcel and upload a sample file and get help there: www.teachexcel.com/talk/microsoft-office?src=yt
It depends on many factors, go ahead and upload a sample file and any associated data to the forum www.teachexcel.com/talk/microsoft-office?src=yt and it will be easier to help.
now i can sleep peacefully.
you have made my night.
i was searching for this for 2 days.
Finally i found the solution of the error while stopping this application.ontime code.
thank you ❤️
Thanks for the great ideas which extend our VBA skills so well.
Here is a thought or two, I find it convenient and less confusing to post comments at the end of code. That eliminates the confusion
while determining if comments precede or follow the code and saves space by reducing lines count, especially as maintenance coders
use different conventions. Spacing is rarely needed and can be better reserved for logical breaks. Also, it is easier to ignore if no longer
needed. With just Tab and Quote keystroke(s) your comments are easily aligned and lengthy lines can be continued with the same keys.
Another freebie: Copy the complete Sub/Function title line to the end of the End Sub/Function line, press Tab, Quote, Ctrl-v (paste)
yielding "End Sub 'Sub macro_timer()" -- which is helpful when spinning through modules with many Sub's, Function's, etc. since you
see where you are without needing to page-up, and will see the full argument structure for the code above. Together giving:
Sub macro_timer()
' TeachExcel.com
interval = Now + TimeValue("00:00:05") ' Set your interval here
Application.OnTime interval, "my_macro" ' Tells Excel when to next run the macro.
End Sub 'Sub macro_timer()
Ah, very interesting, thanks for those tips! I definitely am happy to get tips and notes on what works well))
Thank you so much, I was working on this type program since a long period, but was facing problem everytime, now I got it done. Thanks a Ton... :-)
Excellent. Great piece of small and efficient code, thank you.
Really Interesting,Helpful Tutorial Thank You Sir :):):)
Nice one! Thanks for sharing this technique :)) Thumbs up!!
I was thinking about that few days ago;) kudos for tutorial on time xD
haha, thats great))
Really Helpful Thank You Very Much
Very useful, Thank you.
Great job, thank you verry much
I love this one! Useful in my multiple macro set up. Is there a way that excel can send a command using ssh, without a need of another program like putty?
I feel like it is better to go through another program, but there is a chance you could do it all through a macro, I'm really not sure.
Hi,
Can you pls explain how to Automatize data with outlook email using macro?
Excellent one. Help me how to access web portal and generate reports
Thanks) Your question is a pretty big one and the solution depends on a lot of factors, you can ask in our forum on teachexcel and upload a sample file and get help there: www.teachexcel.com/talk/microsoft-office?src=yt
Hehe.....Easy Peasy. Thanks a lot.
When ever I do hyperlink to a cell. It takes much time to open and in some cases it will open can I know the reason?
It depends on many factors, go ahead and upload a sample file and any associated data to the forum www.teachexcel.com/talk/microsoft-office?src=yt and it will be easier to help.
Please present it clearly