07 Wb opened w/ 03 and it Reopens after Close
Closed
Josh
-
May 11, 2012 at 08:23 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 9, 2012 at 07:47 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 9, 2012 at 07:47 PM
Related:
- 07 Wb opened w/ 03 and it Reopens after Close
- Qbittorrent close after download - Guide
- Close all tabs chrome android - Guide
- How to close intel performance telemetry - Guide
- How to close music on iphone - Guide
- Hp laptop close lid options - Guide
6 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 11, 2012 at 05:59 PM
May 11, 2012 at 05:59 PM
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 January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 14, 2012 at 05:23 PM
May 14, 2012 at 05:23 PM
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 January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 17, 2012 at 06:29 PM
May 17, 2012 at 06:29 PM
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 January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 26, 2012 at 07:47 AM
May 26, 2012 at 07:47 AM
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 January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 30, 2012 at 03:14 AM
May 30, 2012 at 03:14 AM
I am confused over the three events that you have coded for . What is your intent here for each event?
Didn't find the answer you are looking for?
Ask a question
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 August 8, 2012
Status
Contributor
Last seen
October 12, 2012
Oct 8, 2012 at 07:59 AM
Oct 8, 2012 at 07:59 AM
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 January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Oct 9, 2012 at 07:47 PM
Oct 9, 2012 at 07:47 PM
Could you post a sample book that can show the issue.