View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Omega[_2_] Omega[_2_] is offline
external usenet poster
 
Posts: 1
Default 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