Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
Adelinadia din Mures
 | Femeie
25 ani
Mures
cauta Barbat
27 - 71 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
TRaPModerator
Postari: 960
|
|
I use a temporary excel file called export.xlsx for various data extractions, I get what I need from the file then I want to close it. I might use it even 100 times in 1 day so I need excel to stop asking me if I want to save every time.
I use VBA to close the file without prompting me to save. Source: https://stackoverflow.com/questions/248 ... out-prompt
I personalized it to my excel file name (since I am always using export.xlsx as a name) and this way I make sure I always close export.xlsx no matter which is my ActiveWorkbook.
Sub CloseBook2()
Workbooks("export.xlsx").Close savechanges:=False
End Sub
|
|
|
| |
|
