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.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
love_oana
 | Femeie
31 ani
Bucuresti
cauta Barbat
31 - 45 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 787
|
|
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:
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
|
|
|
| pus acum 6 ani |
|