Hi again Syed

That is a mystery. It should in your case, since you are licensed to use it in both
runtime and designtime mode. But there are bugs in'97, and there are potential version
conflicts in all instances of external components -my very best tools recently crashed
during some "service pack". Anyway, it would probably not work on another computer or with
another user with fewer licenses and priviledges.

... a very long "I have no idea" reply :-)
--
HTH. Best wishes Harald
Followup to newsgroup only please.

"Syed Zeeshan Haider" wrote in message
...
Thank you very much, Harald!

It worked very well.
I love simple examples like you posted. They make the complex tasks easier.

But I am still wondering why doesn't CommonDialog box work with VBA for
Excel 97 Pro?

Thanks again!
--
Syed Zeeshan Haider.
http://szh.20m.com/


-----------------------------------
Allah says to Mankind:
"Then which of the favours of your Lord will ye deny?"