Hi Robin,

I really appreciate your help. The code works, only that I need t
declare the function at the top of standard VBA module, which took m
an hour to find out. hehe

At this level, I wonder if you or anyone else knows how to turn to
certain page when the pdf file opens, or even a certain paragraph
line. I know html is able to work like that, and adobe has 'go to...
function. but not sure how to fix that in VBA code.

Thank you. I found more and more fun in VBA now :)

Fendi

--
Fendi
-----------------------------------------------------------------------
Fendic's Profile: http://www.excelforum.com/member.php...fo&userid=2395
View this thread: http://www.excelforum.com/showthread.php?threadid=37583