Hi Tom,

I wanted to add one more doubt to my list.

Why was the error coming only at the Chrw function?

I have some other keywords in the same sub, so why doesnt the "Missing
reference" cause the compile error in a keyword before Chrw?

Thanks a lot,
Hari
India

"Hari Prasadh" wrote in message
...
Hi Tom,

Thnx a lot

Did as you suggested and it is working now.

Im surprised as to why should references be missing from one workbook to
another. Arent these references Global level settings.

Actually in my case I had a missing reference for MS PPT libraray 11.0
while am using Office 2002? (it could be possible because I keep on
copying my personal workbook from home - 2003 to my office - 2002)

Please note, though I was trying to automate PPT using excel (Jon P's
code) in other subs the present sub (all the subs within personal.xls) had
nothing to do with PPT automation.

Thanks a lot,
Hari
India