Hi Experts
I have a just two forms and 2 modules in my excel file. sometimes it runs good and sometimes it breaks and Not responding and I have to restart the excel and I am loosing all my non saved data.
Please help!!!
SK
Hi Experts
I have a just two forms and 2 modules in my excel file. sometimes it runs good and sometimes it breaks and Not responding and I have to restart the excel and I am loosing all my non saved data.
Please help!!!
SK
You can not restore not saved data, if you attach your file we can help you to find errors in code
If solved remember to mark Thread as solved
Hi, skhari,
what about adding a line to the start of the procedures to save the workbook (with a Date/Time stamp) before any further action is taken?
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
Hi, Thanks for your reply. That would great if i have some line of code which auto saves the workbook before any further action.
I don't know the reason why my workbook keep crashing frequently. Please help on this too.
Attached the workbook for evaluation.
Thank you for your time
Hi, skhari,
simple question from my side: has your workbook worked without any problesm before you introduced API/ClassProgramming?
Instead
65536 would be the last row in an xls but I prefer to usePlease Login or Register to view this content.
ApplyBorder isn´t available in the Workbook.Please Login or Register to view this content.
To add save maybe just go with the UserForm_Activate and insert a line like
right at the start of that preocedure for any form. Or make it a Sub in a module and call it from there (as well as from the other procedures).Please Login or Register to view this content.
Ciao,
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks