ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   auto prompt file insert object when opening a template (https://www.excelbanter.com/excel-programming/370372-auto-prompt-file-insert-object-when-opening-template.html)

romeeko

auto prompt file insert object when opening a template
 
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

NickHK

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





All times are GMT +1. The time now is 02:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com