Search:

Type: Posts; User: DThib; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    28
    Views
    744

    Re: Looping is killing my Excel 365 VBA code!

    I am sorry, I forgot to add the word doc. Here it is
  2. Replies
    28
    Views
    744

    Re: Looping is killing my Excel 365 VBA code!

    I can drop a copy of the word document setup in dropbox.
    I'll post in a moment


    https://www.dropbox.com/s/xxdy8iaz03vm4ah/F01%20rB%28draft%29.docx?dl=0
    Rename the P31 position to this
  3. Replies
    28
    Views
    744

    Re: Looping is killing my Excel 365 VBA code!

    bump!!
  4. Replies
    28
    Views
    744

    Re: Looping is killing my Excel 365 VBA code!

    The Latest results are (Drum roll, please.:

    The following code is placing the results as requested, but the word doc saved as a pdf is not releasing the memory and thus results are being opened...
  5. Replies
    28
    Views
    744

    Re: Looping is killing my Excel 365 VBA code!

    Bump!!!!
  6. Replies
    28
    Views
    744

    Re: Looping is killing my Excel 365 VBA code!

    Can anyone help me figure out why my code is showing the correct values but it is carrying the previous results into the new document?

    I get all the correct responses but the first document's...
  7. Replies
    28
    Views
    744

    Re: Looping is killing my Excel 365 VBA code!

    bump!
  8. Replies
    28
    Views
    744

    Re: Looping is killing my Excel 365 VBA code!

    I now get all instances of the matching PO being accounted for in each document, but they only show the last records results for all entries.
    The macro gives me the appropriate docs with Sterile PO...
  9. Replies
    28
    Views
    744

    Re: Looping is killing my Excel 365 VBA code!

    My code does create the appropriate word docs and fills the the 2 tables on the word doc. It saves and reopens a new temporary doc but closes after one match for one Sterile PO(should be 3 with set I...
  10. Replies
    28
    Views
    744

    Re: Looping is killing my Excel 365 VBA code!

    I had to add the reference for Microsoft Word 16.o Object Library

    It allows the word code to run in excel.
    That might be part of your hangup
  11. Replies
    28
    Views
    744

    Re: Looping is killing my Excel 365 VBA code!

    Thanks NoSparks

    I have answered Norie's question twice.

    I do not have any merged cells in my Excel data or my word document tables I am writing to.

    My data is found below:
    There area few...
  12. Replies
    28
    Views
    744

    Re: Looping is killing my Excel 365 VBA code!

    Now it actually pulls the correct identity but only the last match for logic conditions.
    I need it to add all matches to the correct tables in Word 365.
    Here is my updated code.

    1) I need help...
  13. Replies
    28
    Views
    744

    Re: Looping is killing my Excel 365 VBA code!

    bump!
  14. Replies
    28
    Views
    744

    Re: Looping is killing my Excel 365 VBA code!

    I have tweaked my code.
    It now looks like this, but is still holding the word doc with the information that should clear for the next Sterile PO# to fill out the document.
    It saves by the SPO and...
  15. Replies
    28
    Views
    744

    Re: Looping is killing my Excel 365 VBA code!

    Bump!

    Please answer my plea
  16. Replies
    28
    Views
    744

    Re: Looping is killing my Excel 365 VBA code!

    No. All cells are non-merged
  17. Replies
    28
    Views
    744

    Re: Looping is killing my Excel 365 VBA code!

    It appears to look at the table find the matching PO# and stop copying at that point instead of copying only the matching PO # rows.
  18. Replies
    28
    Views
    744

    Re: Looping is killing my Excel 365 VBA code!

    Yes.

    Every time I step through the code at the code:

    wordApp.Visible = True

    It pauses and runs, not stopping, to produce the results. But until then it is doing everything right.

    I do not...
  19. Replies
    28
    Views
    744

    Re: Looping is killing my Excel 365 VBA code!

    Hi Norie,

    When I run the code you can see in my string, I produce the 6 PDFs labeled with the PO and the Word doc Content Control showing. Then the code shows the results for the PO group and also...
  20. Replies
    28
    Views
    744

    Re: Looping is killing my Excel 365 VBA code!

    Yes. I have it keying off of the column 6 data. I can also have it pull off the individual ids in column 4.


    Right now it is pulling off of column 6.
  21. Replies
    28
    Views
    744

    Looping is killing my Excel 365 VBA code!

    Hello.

    I have written the below code and it works to create the the correct name and place that value in a Word doc Content Control and then add to the 2 tables the correct information.

    My...
  22. Re: Excel 365 macro to add row to Word 365 for with Content Controls

    Bump!
  23. Excel 365 macro to add row to Word 365 for with Content Controls

    My data is supposed to loop through a list find the matching cell(s) defined by the dictionary and add content to content controls on a word document.

    The code below works, but it will not place...
  24. Re: Excel 365 VBA to take a match of 2 factors to add to Word doc 365 table

    Can anyone help??
  25. Re: Excel 365 VBA to take a match of 2 factors to add to Word doc 365 table

    Bump
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4