07 Wb opened w/ 03 and it Reopens after Close
Closed
Josh
-
11 May 2012 à 08:23
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 9 Oct 2012 à 19:47
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 9 Oct 2012 à 19:47
Related:
- 07 Wb opened w/ 03 and it Reopens after Close
- Qbittorrent close after download - Guide
- *#07# - Guide
- Close all tabs - Guide
- How to close skype account - Guide
- How to close intel performance telemetry - Guide
6 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
11 May 2012 à 17:59
11 May 2012 à 17:59
try to see this
https://www.ozgrid.com/Excel/run-macro-on-time.htm
https://www.ozgrid.com/Excel/run-macro-on-time.htm
rizvisa1:
Thanks for the link and it's a great reference for creating OnTime events, however I'm still lost as to how the folder reopens on its how.
Thank you,
Josh
Thanks for the link and it's a great reference for creating OnTime events, however I'm still lost as to how the folder reopens on its how.
Thank you,
Josh
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
14 May 2012 à 17:23
14 May 2012 à 17:23
what is this "CloseDownTime" ?
rizvisa1:
To be honest, I don't really know. Shows how green I am with coding. In my head, if it doesn't behave like this for excel 07 users, why does it behave like this for excel 03 users?
Any insight would be appreciated.
Thank you,
Josh
To be honest, I don't really know. Shows how green I am with coding. In my head, if it doesn't behave like this for excel 07 users, why does it behave like this for excel 03 users?
Any insight would be appreciated.
Thank you,
Josh
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
17 May 2012 à 18:29
17 May 2012 à 18:29
There are numerous reference to this in your code
I did not spot any place where this is being set
I did not spot any place where this is being set
Is it being set in this line?
CloseDownTime = Now + TimeValue("00:30:00") ' hh:mm:ss
Could it be that this is being set at the wrong time? Shoudl it be set sooner?
Thank you,
Josh
CloseDownTime = Now + TimeValue("00:30:00") ' hh:mm:ss
Could it be that this is being set at the wrong time? Shoudl it be set sooner?
Thank you,
Josh
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
26 May 2012 à 07:47
26 May 2012 à 07:47
That line i did miss.
But i was confused over this
f Not IsEmpty(CloseDownTime) Then Application.OnTime EarliestTime:=CloseDownTime,
Is it possible to post a sample workbook with complete macro's at some file share site and posting back link to the file back here
But i was confused over this
f Not IsEmpty(CloseDownTime) Then Application.OnTime EarliestTime:=CloseDownTime,
Is it possible to post a sample workbook with complete macro's at some file share site and posting back link to the file back here
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
30 May 2012 à 03:14
30 May 2012 à 03:14
I am confused over the three events that you have coded for . What is your intent here for each event?
Josh, did you manage to work out how to resolve this workbook re-opening issue? I'm experiencing this as well and can't quite figure it out.
Thanks
Thanks
ExcelJosh
Posts
12
Registration date
Wednesday 8 August 2012
Status
Contributor
Last seen
12 October 2012
8 Oct 2012 à 07:59
8 Oct 2012 à 07:59
y.pango:
I did not find the solution for it. I've tried a few places to figure it out and everyone is at a loss.
Sorry,
Josh
I did not find the solution for it. I've tried a few places to figure it out and everyone is at a loss.
Sorry,
Josh
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
9 Oct 2012 à 19:47
9 Oct 2012 à 19:47
Could you post a sample book that can show the issue.