Launch Macro Subroutine at Excel Start


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Launch Macro Subroutine at Excel Start

  1. #1
    Join Date
    Feb 2007
    Posts
    13

    Launch Macro Subroutine at Excel Start

    Two questions:

    1-How to run automatically Visual Basic Subroutine Macro at start of excel?
    Sub Auto_Open
    ComboBox1.AddItem "Item1"
    ComboBox1.AddItem "Item2"
    ComboBox1.AddItem "Item...)
    End Sub
    (This is not executing at startup of the Workbook.)

    2-If the launch is a Shell command for Access, how is the Access Window maximized and on top of all the other windows?
    Last edited by <>er@; 02-06-2007 at 12:55 PM.

  2. #2
    Join Date
    Dec 2003
    Posts
    2,750
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

  3. #3
    Join Date
    Feb 2006
    Posts
    11
    Could also just save your macro workbook as an addin (.XLA file) and select from the AddIns menu in Excel so that it is opened whenever Excel is opened.

Similar Threads

  1. Replies: 1
    Last Post: 01-02-2007, 08:58 AM
  2. Excel Macro / modify formulas via user input
    By fatboy in forum VB Classic
    Replies: 2
    Last Post: 01-19-2006, 08:54 AM
  3. activating web links in excel macro
    By cokoliso in forum VB Classic
    Replies: 0
    Last Post: 01-12-2006, 06:35 PM
  4. Using Word commands through an Excel macro
    By Pass0 in forum VB Classic
    Replies: 1
    Last Post: 10-24-2005, 01:26 PM
  5. Cells.find command in Excel Macro Programming
    By Robb in forum VB Classic
    Replies: 1
    Last Post: 06-19-2002, 01:51 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center