>>Thanks very much Cetin. You seem to have an excellent grasp for automation. Two extra questions.
>>
>>1. Do you prefer Excel automation to create graphs over MSGraph and why?
>>2. Is there any docs that outline the PEM's available and how to use them for automation of Word and Excel? Keep in mind I'm an automation newbie and would prefer something not to complicated to begin with. TIA
>>
>>
>1. (Question is extremely hard 50 points would be enough :). I really don't prefer one over another. It changes from app to app and distribution spectrum. If I'm sure it will be used where Excel already (or will) installed then I prefer Excel. Because its control set is much larger then MSGraph and doesn't have some quirks of MSGraph. Can do calculations, support pivot table etc etc (it's Excel :)
>2. Keep cool, I'm also a newbie with automation. Only docs I use are vba*.hlp (vbaxl8.hlp for excel) files located in ..\Microsoft Office\Office. One supporter file is wc0993.exe from MS site (don't know exact place and might be here on UT too-if not I could send it). It's a compressed file containing all VB constants in .bas files (plain ASCII and registered to show with notepad on my system :).
>Cetin
Thanks very much Cetin. As always, your help is greatly appreciated.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.