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