Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Angry macro to Copy data from excel and add it to a possibly existing word docume

    I have an excel file scaffolds.xls and using dget to pull data. There is a dropdown box that you select a work order from and it plugs all the fields in for that work order. I want to assign a macro to a button that looks to see if c:\temp\scaffolds.doc exists. If it does not exist I need the macro to create it. If it does exist I need to paste b2:f7 to it and <enter> (leaving a blank line). The user can then select the next work order and this time and have it copy the newly updated cells below the previously pasted selection. I appreciate any and all help ahead of time.

  2. #2
    New Lounger
    Join Date
    Feb 2012
    Location
    St. Louis, MO
    Posts
    21
    Thanks
    1
    Thanked 2 Times in 2 Posts

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •