|
Help with Excel macro
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 |
Help with Excel macro
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 |
Help with Excel macro
"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 |
Help with Excel macro
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 |
Help with Excel macro
"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 |
| All times are GMT +1. The time now is 08:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com