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
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center