View Single Post
  #1 (permalink)  
Old December 29th, 2006, 05:58 PM
dgr7 dgr7 is offline
Authorized User
 
Join Date: Dec 2006
Location: , , .
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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 desktop 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

Reply With Quote