Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / March 2007

Tip: Looking for answers? Try searching our database.

Start Excel2000 including a makro

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lars - 02 Mar 2007 17:17 GMT
Start Excel2000 including a makro

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

Thanks

Lars
Gord Dibben - 02 Mar 2007 18:00 GMT
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

>Start Excel2000 including a makro
>
[quoted text clipped - 4 lines]
>
>Lars
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.