I have an Excel macro which is designed to minimise and then save the
open/active spreadsheet:


Application.WindowState = xlMinimized

ActiveWorkbook.Save


However, when it operates on one particular spreadsheet - "my work.xls" -
between the minimising and saving I would like it to run another macro
called "alter format". Assuming this is possible, can someone help me with
the code to achieve this please?


Many thanks

Victor Delta;451989 Wrote:
I have an Excel macro which is designed to minimise and then save the
open/active spreadsheet:


Application.WindowState = xlMinimized

ActiveWorkbook.Save


However, when it operates on one particular spreadsheet - "my work.xls"
-
between the minimising and saving I would like it to run another macro
called "alter format". Assuming this is possible, can someone help me
with
the code to achieve this please?


Many thanks

It's unlikely that a macro could be called "alter format", but assuming
it's called "AlterFormat" then this should do it:
Application.WindowState = xlMinimized
AlterFormat
ActiveWorkbook.Save


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=125108

"p45cal" wrote in message
...

Victor Delta;451989 Wrote:
I have an Excel macro which is designed to minimise and then save the
open/active spreadsheet:


Application.WindowState = xlMinimized

ActiveWorkbook.Save


However, when it operates on one particular spreadsheet - "my work.xls"
-
between the minimising and saving I would like it to run another macro
called "alter format". Assuming this is possible, can someone help me
with
the code to achieve this please?


Many thanks

It's unlikely that a macro could be called "alter format", but assuming
it's called "AlterFormat" then this should do it:
Application.WindowState = xlMinimized
AlterFormat
ActiveWorkbook.Save

Thanks. Yes, you're right, I should have put "alter_format".

However, I only want to run the macro on one spreadsheet and so assumed some
sort of if statement would be required...? Is this not the case?

V

Victor Delta;452235 Wrote:
"p45cal" wrote in message
...

Victor Delta;451989 Wrote:
I have an Excel macro which is designed to minimise and then save
the
open/active spreadsheet:


Application.WindowState = xlMinimized

ActiveWorkbook.Save


However, when it operates on one particular spreadsheet - "my
work.xls"
-
between the minimising and saving I would like it to run another
macro
called "alter format". Assuming this is possible, can someone help
me
with
the code to achieve this please?


Many thanks

It's unlikely that a macro could be called "alter format", but
assuming
it's called "AlterFormat" then this should do it:
Application.WindowState = xlMinimized
AlterFormat
ActiveWorkbook.Save

Thanks. Yes, you're right, I should have put "alter_format".

However, I only want to run the macro on one spreadsheet and so assumed
some
sort of if statement would be required...? Is this not the case?

V

Gotcha.
Application.WindowState = xlMinimized
If ActiveWorkbook.Name = "my work.xls" Then AlterFormat
ActiveWorkbook.Save


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=125108

"p45cal" wrote in message
...

Victor Delta;452235 Wrote:
"p45cal" wrote in message
...

Victor Delta;451989 Wrote:
I have an Excel macro which is designed to minimise and then save
the
open/active spreadsheet:


Application.WindowState = xlMinimized

ActiveWorkbook.Save


However, when it operates on one particular spreadsheet - "my
work.xls"
-
between the minimising and saving I would like it to run another
macro
called "alter format". Assuming this is possible, can someone help
me
with
the code to achieve this please?


Many thanks

It's unlikely that a macro could be called "alter format", but
assuming
it's called "AlterFormat" then this should do it:
Application.WindowState = xlMinimized
AlterFormat
ActiveWorkbook.Save

Thanks. Yes, you're right, I should have put "alter_format".

However, I only want to run the macro on one spreadsheet and so assumed
some
sort of if statement would be required...? Is this not the case?

V

Gotcha.
Application.WindowState = xlMinimized
If ActiveWorkbook.Name = "my work.xls" Then AlterFormat
ActiveWorkbook.Save

Many thanks. No "Run" required then?

V