Hi,

Some days back I learned the Chrw () function from this group.

I see that it works in a particular workbook but in another workbook it
fails. Could anybody please guide me.

Thanks a lot,
Hari
India

in the failing workbook, after it fails, go into tools=References and see
if there is a reference marked as MISSING. If so, you need to clear up this
reference by removing it or finding it on that machine.

--
Regards,
Tom Ogilvy

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

Some days back I learned the Chrw () function from this group.

I see that it works in a particular workbook but in another workbook it
fails. Could anybody please guide me.

Thanks a lot,
Hari
India

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

"Tom Ogilvy" wrote in message
...
in the failing workbook, after it fails, go into tools=References and see
if there is a reference marked as MISSING. If so, you need to clear up
this
reference by removing it or finding it on that machine.

--
Regards,
Tom Ogilvy

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