dnickelson
Board Regular
- Joined
- Oct 30, 2003
- Messages
- 118
I've written up some workbooks that perform tasks rather unrelated to excel, or rather, not dependant on the excel application at the moment, they only need excel to open up because I wrote them in vba behind it and\or reference some cells. The end result is that the user doesn't need to interface with excel.
What I'm wondering is what do some of you do to minimize the focus on the excel application when you run into this situation?
Not sure exactly how to make it work nicely but I'd considered making a userform open on entry, hiding the application, and closing the application once the user form is closed. But it had also occurred to me to maybe hide all the toolbars, make just a shell of the window, etc.
I don't want to modify the application the next time they use it, and I'd considered one resolution is not to use excel at all, just go figure out vba, but excel is such a handy interface, everyone has it available, don't have to mess with compiling, etc.
Anyway, mostly looking for ideas, but technical tips would be great.
(as an example, i have one application where i'm just checking to see if they have a dsn set up and setting one up if they don't. or a simpler one might be a hex converter, just need the userform interface, etc.)
Thanks in advance for any idea.
-Dan
What I'm wondering is what do some of you do to minimize the focus on the excel application when you run into this situation?
Not sure exactly how to make it work nicely but I'd considered making a userform open on entry, hiding the application, and closing the application once the user form is closed. But it had also occurred to me to maybe hide all the toolbars, make just a shell of the window, etc.
I don't want to modify the application the next time they use it, and I'd considered one resolution is not to use excel at all, just go figure out vba, but excel is such a handy interface, everyone has it available, don't have to mess with compiling, etc.
Anyway, mostly looking for ideas, but technical tips would be great.
(as an example, i have one application where i'm just checking to see if they have a dsn set up and setting one up if they don't. or a simpler one might be a hex converter, just need the userform interface, etc.)
Thanks in advance for any idea.
-Dan