Prev: macro to automatically send an excel spreadsheet by email
Next: macro open tabs
From: Novice Lee on 12 May 2010 09:42
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
From: FSt1 on 12 May 2010 10:03
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
From: Novice Lee on 12 May 2010 10:07
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
From: JLGWhiz on 12 May 2010 10:10
ActiveWorkbook.Close



"Novice Lee" <NoviceLee(a)discussions.microsoft.com> wrote in message
news:4CB4D4DB-43B0-438D-81A3-A832158D3C36(a)microsoft.com...
> 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


 | 
Pages: 1
Prev: macro to automatically send an excel spreadsheet by email
Next: macro open tabs