Sažetak
Automatizacija omogućuje programski gotovo sve što korisnik može učiniti ručno u programu Microsoft Office Word. No ako imate mnogo teksta koji želite unijeti i oblikovati, možda će biti potrebno mnogo koda. Ako podatke možete predstavljati kao niz oblika obogaćenog teksta (RTF), često možete smanjiti kod automatizacije. Možete stvoriti RTF niz, kopirati RTF niz u međuspremnik, a zatim zalijepiti niz RTF u dokument.
U ovom se članku opisuje kako stvoriti jednostavan primjer Visual Basic koji pokreće Word, stvara novi dokument i dodaje neki oblikovani tekst u dokument pomoću unaprijed ugrađenog RTF niza.
Dodatne informacije
Da biste stvorili ogledni projekt, slijedite ove korake:
-
Pokrenite Visual Basic, a zatim stvorite novu standardnu EXE. Po zadanom se stvara obrazac s nazivom Obrazac1.
-
Dodajte commandbutton u obrazac, dvokliknite commandbutton, a zatim dodajte sljedeći kod u događaj Kliknite.
'sRTF represents the rich-text-formatted string to paste into Word
Dim sRTF As String
sRTF = "{\rtf1\ansi\ansicpg1252\deff0\deftab720{\fonttbl" & _
"{\f0\fswiss MS Sans Serif;}{\f1\froman\fcharset2 Symbol;}" & _
"{\f2\froman\fprq2 Times New Roman;}}" & _
"{\colortbl\red0\green0\blue0;\red255\green0\blue0;}" & _
"\deflang1033\horzdoc{\*\fchars }{\*\lchars }" & _
"\pard\plain\f2\fs24 Line 1 of \plain\f2\fs24\cf1" & _
"inserted\plain\f2\fs24 file.\par }"
'Copy the contents of the Rich Text to the clipboard
Dim lSuccess As Long
Dim lRTF As Long
Dim hGlobal As Long
Dim lpString As Long
lSuccess = OpenClipboard(Me.hwnd)
lRTF = RegisterClipboardFormat("Rich Text Format")
lSuccess = EmptyClipboard
hGlobal = GlobalAlloc(GMEM_MOVEABLE Or GMEM_DDESHARE, Len(sRTF))
lpString = GlobalLock(hGlobal)
CopyMemory lpString, ByVal sRTF, Len(sRTF)
GlobalUnlock hGlobal
SetClipboardData lRTF, hGlobal
CloseClipboard
GlobalFree hGlobal
'Paste into a new Word document
Dim oWord As Object
Dim oDoc As Object
Set oWord = CreateObject("word.application")
Set oDoc = oWord.Documents.Add
oWord.Selection.Paste
oWord.Visible = True -
Dodajte sljedeći kod u odjeljak Opće deklaracije modula obrasca.
Private Declare Function OpenClipboard Lib "user32" (ByVal hwnd As Long) As Long
Private Declare Function RegisterClipboardFormat Lib "user32" Alias _
"RegisterClipboardFormatA" (ByVal lpString As String) As Long
Private Declare Function EmptyClipboard Lib "user32" () As Long
Private Declare Function CloseClipboard Lib "user32" () As Long
Private Declare Function SetClipboardData Lib "user32" ( _
ByVal wFormat As Long, ByVal hMem As Long) As Long
Private Declare Function GlobalAlloc Lib "kernel32" (ByVal wFlags As Long, _
ByVal dwBytes As Long) As Long
Private Declare Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" ( _
ByVal Destination As Long, Source As Any, ByVal Length As Long)
Private Declare Function GlobalUnlock Lib "kernel32" (ByVal hMem As Long) As Long
Private Declare Function GlobalLock Lib "kernel32" (ByVal hMem As Long) As Long
Private Declare Function GlobalFree Lib "kernel32" Alias "GlobalFree" ( _
ByVal hMem As Long) As Long
Private Const GMEM_DDESHARE = &H2000
Private Const GMEM_MOVEABLE = &H2 -
Pritisnite tipku F5 da biste pokrenuti projekt. Word će početi, a zatim će se stvoriti novi dokument koji sadrži oblikovani tekst.
Reference
Dodatne informacije i primjere za razvoj Office rješenja potražite na sljedećim Microsoftovim web-mjestima:
http://support.microsoft.com/ofd http://msdn.microsoft.com/office