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.
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.The hyperlink is grabbing a file/image that is presented in the Document Viewer.
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.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.
The fix is using a correct direct download link. I don't understand your second sentence.So what is the fix? If the fix being acquired is a data image being shared, is there a fix?