Attachment macro in MSwords

[Jamielowmp]

Hi there...
this is my first message in this community. I know there's a lot of benefits in VB macro but i'm not very good at programming (still a basic learner). I have an urgent task that requires me to do a command button for attaching a file in mswords. That means, i'm required to do a macro in an msword template such that when clicked, it automatically perform the same as 'Insert File' where user will browse for the correct file to attach.

I know its should be a simple task but i can't figure out how. Hope someone enlighten me. THANKS!

rgds,
Jamie

[willakawill]

Hi there...
this is my first message in this community. I know there's a lot of benefits in VB macro but i'm not very good at programming (still a basic learner). I have an urgent task that requires me to do a command button for attaching a file in mswords. That means, i'm required to do a macro in an msword template such that when clicked, it automatically perform the same as 'Insert File' where user will browse for the correct file to attach.

I know its should be a simple task but i can't figure out how. Hope someone enlighten me. THANKS!

rgds,
Jamie

Hi. Here is the code that will start you off;

Private Sub CommandButton1_Click()
    Dim strFileName As String
    
    strFileName = SelectFile()
    Selection.InsertFile strFileName
End Sub

Function SelectFile() As String
With Dialogs(wdDialogFileOpen)
    If .Display Then
        SelectFile = WordBasic.FilenameInfo$(.Name, 1)
    Else
        SelectFile = ""
    End If
End With
End Function

[Jamielowmp]

Hey...thanks!!! !!
So, if i want to display the selected file as a link, i'll have to enhance the code with a "display as link" command right?

[Killer42]

Hi.

I see you got what you needed from willakawill. However, here's an observation that may serve you well in future.

The easiest way to get started with a macro in Word is to record it. Then you can go in and edit it. Give it a try some time, it gives you a big head-start.

[Killer42]

Hey...thanks!!! !!
So, if i want to display the selected file as a link, i'll have to enhance the code with a "display as link" command right?

Yeah, I believe it's an option on the InsertFile method.

[Jamielowmp]

hi willakawill,
i've managed to get what i wanted by developing from your code u guided me from. Thanks so much!