would like to copy infor into word - help!

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • Help please

    I am trying to make a basic IT report at work and would like to copy certain screens and put them into my report. Th only problem is that when I press print screen and then paste into word it pastes the whole screen.

    Sometimes I would just like a box that opened or a certain window to appear. Can anyone tell me how to do this.

    Much appreciated


  • Sure there is ptobably a better way, but this may help you.

    Try using the print screen button

    Then open up MS paint.

    Edit > Paste

    Crop the part you want to use.

    Save that file.

    Now you can attach the file in a few formats depending on your requirements.

    Hope this helps

  • This will get a selected range in VBA over into Word, I have added a few lines so you can edit as needed, let me know if you require more assistance

    Kindest possible regards

    Jack in the UK


    Attribute VB_Name = "Module1"
    Sub Excel_to_Word_JackintheUK()


    Set Word6 = CreateObject("Word.Basic")
    With Word6
    If UCase(Left(Application.OperatingSystem, 3)) <> "MAC" Then
    .AppMaximize 1
    AppActivate "Microsoft Word"
    End If
    .Insert "Jack - Test from Excel"
    .startofline 15
    ' .Bold
    ' .CenterPara
    '.startofline 15
    Selection.PasteSpecial Paste:=xlValues, operation:=xlNone, _
    skipblanks:=False, Transpose:=False
    Application.CutCopyMode = False

    End With

    End Sub

  • Lynda
    I'm not sure whether the screens you're referring to are "excel screens". If so then Jack's answer will be right. If you don't want to use VBA then copying and pasting will do the job.

    Note that if the range you're copying is a named range and you insert it as a paste link and subsequently insert rows or columns (within the named area) then (when refreshed) the item viewed in word will grow to accomodate the larger area.

    If the screens you're pasting are not excel but purely images you'll need to use a graphics editor to "crop" the image to size before you paste it in. Note that even simple graphics editors such as Microsoft Photo Editor will allow you to do this.

    Hope this helps.

    Robert Hind
    Perth - Western Australia

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!