LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 22,906
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I want to count days between two dates including start date Infinitebiscuit Excel Worksheet Functions 2 February 20th 07 12:27 PM
Starting a Makro automatically [email protected] Excel Discussion (Misc queries) 5 July 24th 06 12:19 PM
Makro in excel Ted Excel Worksheet Functions 6 June 28th 06 02:06 PM
If with a makro Tove Excel Discussion (Misc queries) 1 April 12th 05 01:49 PM
Makro Esrei Excel Discussion (Misc queries) 1 March 1st 05 12:34 PM


All times are GMT +1. The time now is 08:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"