control Excel VBA macro with a VB 05-designed user interface


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: control Excel VBA macro with a VB 05-designed user interface

  1. #1
    Join Date
    Dec 2006
    Posts
    23

    control Excel VBA macro with a VB 05-designed UI

    hello,
    I have many Excel workbooks that I receive from clients I run various Excel VBA macros on depending on which workbook it is, and I need to automate all of this so that I can run an simple .exe user interface designed in VB 2005 Express Edition where when that interface is run, a small window opens on the destop with a group of buttons, when the user clicks one of the buttons, Excel launches loads the appropriate file and runs an already-existing appropriate Excel macro, then some file maintenance is done, like moving a group of files from one subdirectory to another.
    I'm new to VB and don't know where to start to make this happen. Could someone show me how to do this/where to begin?
    thanks in advance,
    david
    Last edited by dgr7; 12-28-2006 at 03:13 PM.

  2. #2
    Join Date
    Dec 2003
    Posts
    2,750
    You can execute macros in Office applications using automation:

    How to run Office macros by using Automation from Visual Basic .NET
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

Similar Threads

  1. Excel Macro / modify formulas via user input
    By fatboy in forum VB Classic
    Replies: 2
    Last Post: 01-19-2006, 09:54 AM
  2. Cacheing a User Control and Postback
    By sr in forum ASP.NET
    Replies: 0
    Last Post: 04-17-2003, 11:14 AM
  3. Script for scrolling
    By Mark in forum Web
    Replies: 3
    Last Post: 08-30-2001, 12:45 PM
  4. Interface leaks in C#?
    By Kevin Burton in forum .NET
    Replies: 12
    Last Post: 10-09-2000, 11:29 AM
  5. VB vs. Access user interface
    By Ken McLean in forum authorevents.vaughn
    Replies: 1
    Last Post: 05-30-2000, 10:25 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