Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. natureboy

    "Operation is not permitted" error when attempting to SAVE A COPY

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

    "Operation is not permitted" error when attempting to SAVE A COPY

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

    "Operation is not permitted" error when attempting to SAVE A COPY

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

    "Operation is not permitted" error when attempting to SAVE A COPY

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

    Luanch a browser, fill in a field, puke.

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

    Extract embedded files from an Excel sheet to a directory

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

    Excel: how do I get the filename from an embedded oject?

    Thanks Skip! That did the trick. Best, Greg
  8. natureboy

    Excel: how do I get the filename from an embedded oject?

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

    Excel: how do I get the filename from an embedded oject?

    (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...
  10. natureboy

    Up to Office XP from 2000 WITHOUT upgrading VBA?

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

    Up to Office XP from 2000 WITHOUT upgrading VBA?

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

Part and Inventory Search

Back
Top