p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Excel VBA (http://p2p.wrox.com/forumdisplay.php?f=79)
-   -   control Excel VBA macro with a VB 05-designed UI (http://p2p.wrox.com/showthread.php?t=52076)

dgr7 December 29th, 2006 05:58 PM

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



All times are GMT -4. The time now is 01:08 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.