'Primer 14: Kolekcije i osnovni objekti u Word-u (Application, Documents, ActiveDocument, Selection) Sub pozivnice() Dim zvanice As New Collection zvanice.Add "Jessica Alba" zvanice.Add "Eva Mendes" zvanice.Add "Angelina Jolie" zvanice.Add "Pamela Anderson" Dim sDir As String sDir = "C:\g3\prog\" If Not FileOrDirExists(sDir) Then MsgBox "Katalog koji ste zadali kao mesto za cuvanje pozivnica ne postoji! Odustajemo..." Exit Sub End If Dim zvanica As Variant 'For Each naredba zahteva ili promenljivu tipa Variant ili promenljivu tipa Object For Each zvanica In zvanice Application.Documents.Add 'CStr vrsi konverziju tipa promenljive zvanica iz Variant u String; u protivnom funkcija odrediIme javlja gresku Selection.TypeText "Dear " & odrediIme(CStr(zvanica)) & "," Selection.TypeParagraph Selection.TypeParagraph Selection.TypeText "It will be an honor to have you as a guest on our party." Selection.TypeText " The show begins at 20:00. Don't be late." Selection.TypeParagraph Selection.TypeText "Feel free to bring a (lady-)friend." Selection.TypeText " We have enough boys over here." Selection.TypeParagraph Selection.TypeParagraph Selection.TypeText "Sincerely," Selection.TypeParagraph Selection.TypeText "your true admirer" ActiveDocument.SaveAs (sDir & zvanica & ".doc") ActiveDocument.Close Next End Sub Function odrediIme(punoIme As String) As String Dim niz() As String niz = Split(punoIme, " ") odrediIme = niz(0) End Function Function odrediPrezime() As String Dim niz() As String niz = Split(punoIme, " ") odrediIme = niz(1) End Function Function FileOrDirExists(PathName As String) As Boolean 'Macro Purpose: Function returns TRUE if the specified file ' or folder exists, false if not. 'PathName : Supports Windows mapped drives or UNC ' : Supports Macintosh paths 'File usage : Provide full file path and extension 'Folder usage : Provide full folder path ' Accepts with/without trailing "\" (Windows) ' Accepts with/without trailing ":" (Macintosh) Dim iTemp As Integer 'Ignore errors to allow for error evaluation On Error Resume Next iTemp = GetAttr(PathName) 'Check if error exists and set response appropriately Select Case Err.Number Case Is = 0 FileOrDirExists = True Case Else FileOrDirExists = False End Select 'Resume error checking On Error GoTo 0 End Function