Hi,

I am working on an application of which the front end is Access, the
backend is Excel. Basically all important parameter values are stored
in the Access, which calls Excel to do the modeling work. In the end
some of the results would be saved in the access.

As the modeling Macro takes some time, I implemented a progress bar in
excel to let people know the status of the job. I made one by following
the J-Walker's example. http://j-walk.com/ss/excel/tips/tip34.htm. It
runs greatly.

But I want to show the Userform(progress bar) When people working in
the Access. I don't want people to see the excel file, so in automation
I use the default,setting, which means the opened excel file is
invisible. But I can not see the progress bar either. Is there some way
to bring the excel user form to the front? I tried different ways, such
as set the visible property of the excel file at different places;The
results is not satisfactory. after doing some reseach, I think calling
some Win API may be helpful. I tried "SetForegroundWindow", and
"FindWindow", but it still does not work.

If Anyone has experieces in this, Can you give me some suggestions?

Thanks
mark li