Hello everybody
I have this code
The macro called (ClearRange) to clear the range A1:C10 >>
Please Login or Register to view this content.
The macro called CloseMe have to restore data after 10 seconds
When I run CloseMe I encountered an error messgage (Excel has stopped working) .. Check online for a solution....
What is the problem with the code?
I get an error with the SaveChanges.
What type of variable is this, what value does it have and what do you expect to happen?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
The macro is simlilar to Undo .. i want to undo the clearcontents code by running the macro CloseMe .. not to save the changes!
It's not clear to me how you expect this to work unless you keep a copy of what you started with somewhere and then reinstate it when you close the workbook.
But why are you changing something and then re-instating it?
OK I fixed it ..
The idea is that the user will use a button to restore the data if he has made some mistakes .. He will click the button named (Restore) to restore data and to close the wb for him. that's allPlease Login or Register to view this content.
Now Is it possible to add a line which opens the same wb again?
how about:
Please Login or Register to view this content.
Best Regards,
Kaper
thanks Mr. Kaper
I tested but it seems impossible to open the wb after closing it as the line of close is running first so how it can be opened again!
FYI, your original code works fine for me, as I would expect, so I suspect something else is interfering. What is the purpose of the Savechanges variable?
Remember what the dormouse said
Feed your head
The purpose is not to save the last changes by putting the value False for it
But where is it used?
Hi,
Maybe this ?
RegardsPlease Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
Hi, Yassir,
two questions: why wait for 10 seconds to close down? Will your code restore data after the user has saved the workbook either prior to starting the procedure or while waiting for the 10 seconds? I´m afrasid the answer to my last question is no so you should consider different ways to restore (generally store within another sheet or an array and restore from there).
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Waiting for 10 seconds just to make the user wait.. If it isn't necessary we can get rid of it.
The most important point is how to close the WB without saving and reopen it again !!
Or is there a nother way to restore data without helper sheets (arrays are acceptable)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks