Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
closing file
Hello,
I have a module that sorts data for me. part of the code opens a source file then saves it to another directory with todays date and adds a number to it it there is another file with that same name. my question is how can i close the save as file, Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
closing file
hi
the saved file should be the active file so add a line of code to the macro. ActiveWorkbook.Close this assumes no changes were made to the saved file. if changes were made, then it needs to be saved again. ActiveWorkbook.Close True regards FSt1 regards FSt1 "Novice Lee" wrote: Hello, I have a module that sorts data for me. part of the code opens a source file then saves it to another directory with todays date and adds a number to it it there is another file with that same name. my question is how can i close the save as file, Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
closing file
Thanks that was it
"FSt1" wrote: hi the saved file should be the active file so add a line of code to the macro. ActiveWorkbook.Close this assumes no changes were made to the saved file. if changes were made, then it needs to be saved again. ActiveWorkbook.Close True regards FSt1 regards FSt1 "Novice Lee" wrote: Hello, I have a module that sorts data for me. part of the code opens a source file then saves it to another directory with todays date and adds a number to it it there is another file with that same name. my question is how can i close the save as file, Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
closing file
ActiveWorkbook.Close
"Novice Lee" wrote in message ... Hello, I have a module that sorts data for me. part of the code opens a source file then saves it to another directory with todays date and adds a number to it it there is another file with that same name. my question is how can i close the save as file, Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to skip the save file notoification on file closing? | Excel Worksheet Functions | |||
Closing a file | Excel Programming | |||
Open external data (varying file names) and closing file once data is retrieved | Excel Programming | |||
VBA Closing File | Excel Programming | |||
VBA closing one file | Excel Programming |