control Excel VBA macro with a VB 05-designed UI
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,
Last edited by dgr7; 12-28-2006 at 02:13 PM.
Microsoft MVP (Visual Basic)
By fatboy in forum VB Classic
Last Post: 01-19-2006, 08:54 AM
Last Post: 04-17-2003, 10:14 AM
Last Post: 08-30-2001, 11:45 AM
By Kevin Burton in forum .NET
Last Post: 10-09-2000, 10:29 AM
By Ken McLean in forum authorevents.vaughn
Last Post: 05-30-2000, 09:25 PM
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