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

[dgr7]

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

[willakawill]

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

Hi david,
This is not too difficult for a programmer with a couple of months experience and might take a couple of days to put together. What is missing for you is the 'couple of months'. As a learning project this is fairly advanced although it could work for you.

You are going to have to learn this step by step. If you use vb2005 then you will neet to learn vb.NET programming from the start. There are no shortcuts. Enthusiastic as they are, I doubt that any of the contributors here will write this entire project for you.

When you have worked through some of the code and get stuck come back and get assistance here or in the .NET forum

Good luck