Acrobat Reader 6.0, the PDF is an OLE embedded file in an Excel Spreadsheet (though I'm not sure that matters). After opening the file, I attempt to save a copy. I choose the destination and select ok - get the error, "The document could not be saved. This operation is not...
Can somebody please help...I'm running the following code to launch a web browser and fill in a field with a path, but I get "Object variable not Set" error:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
URL = "http://susoe01/testing/upload/"
ActiveWorkbook.FollowHyperlink...
Hello,
I need a bit of help extracting a copy of an embedded OLEObject file from a sheet and saving it to a local directory. Here's the snippet of code to originally embed the PDF file:
Sub AttachDocumentation()
NumDocs = InputBox("How Many **Documentation** files do you wish to...
(Note: I'm a VBA newbie...be kind:)
I have a spreadsheet with some embedded PDF files. The files are attached with the following code:
NumDocs = InputBox("How Many **Documentation** files do you wish to attach?")
Dim DocPath As String
i = 0
MsgBox "Select the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.