View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default auto prompt file insert object when opening a template

You can use Application.GetOpenFilename to get the path and filename to
insert.
Record a macro when inserting an object.
Combine the 2 parts.

NickHK

"romeeko" wrote in message
...
I want a template that will prompt a user for the file location of a PDF

that
they can pick which PDF they want and it will automatically do the
insert---object---- Adobe 7.0 file