Rezime
Uz automatizaciju možete da uradite programski skoro sve što korisnik može ručno da uradi u programu Microsoft kancelarija Word. Međutim, ako imate mnogo teksta koji želite da unesete i oblikujete, možda će biti potrebno mnogo koda. Ako podatke možete da predstavite kao nisku u formatu obogaćenog teksta (RTF), često možete da smanjite kôd automatizacije. Možete da kreirate RTF nisku, kopirate RTF nisku u ostavu, a zatim nalepite RTF nisku u dokument.
Ovaj članak opisuje kako da napravite jednostavan primer Visual Basic koji pokreće Word, kreira novi dokument i dodaje neki oblikovani tekst u dokument pomoću unapred ugrađene RTF niske.Više informacija
Da biste napravili primer projekta, pratite ove korake:
-
Pokrenite Visual Basic, a zatim kreirajte novi Standard EXE. Podrazumevano se kreira obrazac pod imenom "Obrazac1".
-
Dodajte komandno dugme u obrazac, kliknite dvaput na komandno dugme, a zatim dodajte sledeći kôd događaju Click.
'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 sledeći kôd u odeljak "Opšte deklaracije" modula "Obrasci".
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 taster F5 da biste pokreneli projekat. Pokreće se Word i kreira se novi dokument koji sadrži oblikovani tekst.
Reference
Za više informacija i uzorke za razvoj Kancelarija rešenja posetite sledeće Microsoft veb lokacije:
http://support.microsoft.com/ofd http://msdn.microsoft.com/office