Two Excel VBA Quezzies
First question,
Is there any way to get a listing of system and/or user data sources
from a VBA app?
Second question,
Is there any way to have a form that is displayed show WHILE Excel is
minimized? So far I can get the form to show and Excel to minimize,
but it takes the form with it. Interestingly enough, if I click the
taskbar entry for the program, only the foreground form displays. But
if I programatically manipulate Excel to be maximized (or normal), the
whole program comes back.
This is purely aesthetics, but I'd like to be able to develop a nice
polished interface where possible. If anyone is wise in the ways of
Excel and it's events and objects, this is a tricky one.
I'm sure there are more to come! Thank you in advance to anyone who
responds.
- Alexander Trauzzi
|