Search results

  1. A

    Why does adding MsgBox change my results?

    Re: Why does msgbox seem to change my subroutine? It still fails when I breakpoint. It works correctly when I have the msgbox.
  2. A

    Why does adding MsgBox change my results?

    Re: Why does msgbox seem to change my subroutine? Yes. It just doesn't make any sense to me whatsoever why it's repeating the second bookmark name.
  3. A

    Why does adding MsgBox change my results?

    Why does msgbox seem to change my subroutine? I am trying to add bookmarks dynamically in VBA to a pdf file. Here is the relevant code: For Each element In OfficeArray AVYourDoc.FindText element, True, True, True AcroApp.MenuItemExecute ("NewBookmark")...
  4. A

    Why does adding MsgBox change my results?

    I am trying to add bookmarks dynamically in VBA to a pdf file. Here is the relevant code: For Each element In OfficeArray AVYourDoc.FindText element, True, True, True AcroApp.MenuItemExecute ("NewBookmark") PDBookmarker.GetByTitle PDYourDoc, "Untitled"...
  5. A

    I pass sub a reference name, it gives me the GUID

    For instance I want to be able to say msgbox OutputGUID("Acrobat") and have it output {E64169B3-3592-47D2-816E-602C5C13F328} Possible?
  6. A

    inserting VBA code in another workbook

    Got it... so close to getting all this working
  7. A

    inserting VBA code in another workbook

    Is there a way to, with VBA, change programmatic access?
  8. A

    inserting VBA code in another workbook

    I exported a ThisWorkbook.cls file. Is there a way, in VBA, to automatically append this cls file to a given book as I export/create it?
  9. A

    inserting VBA code in another workbook

    In VBA, I want to create a new workbook that has specific VBA code (which I would somehow pass/define to the process) in the ThisWorkbook module. Possible?
  10. A

    Copy in a worksheet from another workbook

    Trying to just close book2 without saving changes to "keep" the sheet that was moved, but it's not really getting rid of the warnings because it's asking me to update cell references (which I want to make dynamic anyway). Private Sub Workbook_Open() If WorksheetExists("Summary") =...
  11. A

    Copy in a worksheet from another workbook

    Is this going to infinite-loop me if it's an on-open event? What is late-binding? I also need it to not literally move the sheet, since I need to re-use it later.
  12. A

    Copy in a worksheet from another workbook

    Got back in and control+breaked hardcore XD Back in safely now
  13. A

    Copy in a worksheet from another workbook

    It's part of my Open Workbook subroutine I am afraid to reopen the file now... it's going to spam the hell out of me before I can even edit it
  14. A

    Copy in a worksheet from another workbook

    That just flooded my task manager with repeated openings of EXCEL.EXE -- I don't know if that was intentional out of malice or a genuine mistake, but either way, it did not work as desired.
  15. A

    Copy in a worksheet from another workbook

    Well if I do the record macro I get very similar syntax but if I try to make it dynamic, it fails.
  16. A

    Copy in a worksheet from another workbook

    If I try copying to activeworkbook.sheets(1) it doesn't give the subscript out of range error anymore but it now yields "copy method failed"
  17. A

    Copy in a worksheet from another workbook

    All I can find is code explaining how to copy active sheets to other books, but that's not what I want. I want to open an Excel file and have it extract a sheet from another workbook and add it in. Possible? I have this code on my workbook open event Private Sub Workbook_Open() If...
  18. A

    I have a form that outputs a datasheet, but I want to prevent people from hiding cols

    How do I prevent someone from right clicking a column and Hiding it?
  19. A

    select * from table1 where the entry is not in table2

    How do I do this?
  20. A

    Correct code for opening a recordset from another database?

    There was a custom function "rdate" in the module in the otherdb -- just had to copy that function over to the local db in a new module. Apparently functions in other databases need to be copied over locally if they are used in such expressions.
Back
Top Bottom