drom
Well-known Member
- Joined
- Mar 20, 2005
- Messages
- 521
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
Hi and Thanks in advance!
I am opening a file and saving every sheet in this opened file as a single sheet in a folder after deleting names, links and so on.
Usually some of my Excel books may have 20/25 sheets.
My macro works fine, i cant put here The code because i am doing somany thing with The sheets, but The macro at least I think so works fine.
Once I finish saving this sheets, I try to close this recently opened file, and some times I have no problems (>85% / 95%) ?
Before closing The file i send a message to let me know every thing goes fine
But 5/15% of The time.:
Any idea with maeby a few lines I should add Before closing a file like????
Thanks again
I am opening a file and saving every sheet in this opened file as a single sheet in a folder after deleting names, links and so on.
Usually some of my Excel books may have 20/25 sheets.
My macro works fine, i cant put here The code because i am doing somany thing with The sheets, but The macro at least I think so works fine.
No error messages, no bugs, compilación erros...
Once I finish saving this sheets, I try to close this recently opened file, and some times I have no problems (>85% / 95%) ?
Before closing The file i send a message to let me know every thing goes fine
VBA Code:
MsgBox "Hi, 100% OK ", vbInformation, "I am happy"
- When closing The file Excel App goes down and I have to restart Excel.?
Any idea with maeby a few lines I should add Before closing a file like????
VBA Code:
Application.DisplayAlerts = False
Application.CutCopyMode = False
'Anything else?????
WKB.Close False. 'WKB is the workbook I am opening, exist and I am using this variable many ttimes through The file .
Thanks again