ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Start Excel2000 including a makro (https://www.excelbanter.com/setting-up-configuration-excel/133086-start-excel2000-including-makro.html)

Lars[_2_]

Start Excel2000 including a makro
 
Start Excel2000 including a makro

like Excel.exe c:\..\bok1 makro1 The makro will start autm without press
makro button

Thanks

Lars



Gord Dibben

Start Excel2000 including a makro
 
Lars

You can't run a macro from a command line but you can run a macro when the
workbook opens.

Private Sub Workbook_Open()
Your Code or macro name goes here
End Sub

Right-click on the Excel logo left of "File" on menu and select "View Code"
If workbook is not maximized click on the Logo on the title bar.

Paste the above into that module.

Command line will read C:\....yourpath\file name


Gord Dibben MS Excel MVP

On Fri, 2 Mar 2007 18:17:37 +0100, "Lars" wrote:

Start Excel2000 including a makro

like Excel.exe c:\..\bok1 makro1 The makro will start autm without press
makro button

Thanks

Lars




All times are GMT +1. The time now is 02:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com