DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Threaded View

  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 02:13 PM.

Similar Threads

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

Bookmarks

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


Top DevX Stories

Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL


Sponsored Links