One approach is to first open the file with a shell command:

Sub Macro1()
x = Shell("cmd.exe /c C:\Userguide.pdf", 1)
End Sub

and then use SendKeys to implement the copy/paste.

http://msdn.microsoft.com/library/de...56c24affdd.asp
--
Gary''s Student


"Kishor" wrote:

How can i write a macro in excel to open a pdf file and copy data by select
all command then paste it on excel worksheet ?

ManyManyThanksInAdvance
Kishor.