Recent content by natureboy

Eggles - thanks for your help, but I think I may have solved my problem. Sometimes the simplest answer is the most overlooked. I believe the problem has to do with how the Reader opens the file. I noticed the title bar in Reader says, "Adobe Reader - [PKG1E14.PDF - Linked File]&quot...

To give you a little background: I manage an Engineering organization that is resposible for test and certification of heterogeneous computer environments, typically in a Storage Area Network. The Test Engineers verify that all the combined software and hardware components properly work...

Yup. These are typically VISIO diagrams saved as a PDF, then attached to the the spreadsheet via a ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ActiveSheet.OLEObjects.Add(Filename:= thefile, Link:= False, DisplayAsIcon:=False).Select...

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...

Anyone? Beuller?

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...

Thanks Skip! That did the trick. Best, Greg

Thanks for the suggestion Skip. With the new code, I get a runtime error 1004 - the SourceName in the Objects window shows: SourceName : <Application-defined or object-defined error> : String Is Excel unable to handle PDF attachments? G

(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(&quot;How Many **Documentation** files do you wish to attach?&quot;) Dim DocPath As String i = 0 MsgBox &quot;Select the...

xlbo and krinid - Thanks for your insights and offer for assistance! My system has W2K SP2 with Office 2000 SR-1 (worked ok) Failure system #1: W2000 SP3, Office XP Failure system #2: WinXP, Office XP My VBA code was for Excel. I made some unrelated changes to improve funtionality of my...

Hi Kristina, I'm having a similar issue with some macros I wrote. They work fine with Excel 2000, but fail when running against Excel XP. In particular, I have a macro that copies/pastes rows that contain pick lists - via Selection Validation. The macros work perfectly with Excel 2000, but...