Saving a PDF after it is opened via Excel hyperlink

[J Harper]

How can I automate the saving of a PDF file after it is opened via an Excel hyperlink? I open the pdf file via hyperlink and then save to a specific subdirectory after naming the file. I need to do this 100s of times within each Excel.

 

[J Harper]

I changed to the suggested code. I did not get an error, BUT not files were copied. Examples of the hyperlinks are listed in the attached HYPERLINKS STRING file.

Thank you for your help!

 

[John_w]

The hyperlink is grabbing a file/image that is presented in the Document Viewer.

In that case the code can't download the file (what is the Document Viewer?) You need to change the hyperlinks to direct download links.

I tried it with a Google Drive shareable link and the code appeared to work, but downloaded a 'PDF' file which couldn't be opened. When I changed the shareable link to a direct download link the code downloaded a valid PDF file to the specified folder.

 

[J Harper]

Tne macro now creates the PDFs without giving and error, BUT when I try to open the files I get and error " We cannot open this file" as seen in the attachment.

 

[John_w]

Tne macro now creates the PDFs without giving and error, BUT when I try to open the files I get and error " We cannot open this file" as seen in the attachment.

Which is basically the same error that I got with a shareable link. With a correct direct download link pasted into the address bar of your browser it should open a file open/save dialogue allowing you to download the file and the same link should work with the macro.

 

[J Harper]

So what is the fix? If the fix being acquired is a data image being shared, is there a fix?

The other approach would to be open the file and then save, BUT your approach is much better.

Any ideas?

 

[John_w]

So what is the fix? If the fix being acquired is a data image being shared, is there a fix?

The fix is using a correct direct download link. I don't understand your second sentence.