Kako da nalepite nisku za oblikovanje obogaćenog teksta u Word pomoću Visual Basic Automation

Rezime

Uz automatizaciju možete programski da uradite gotovo sve što korisnik može da uradi ručno u programu Microsoft Office Word. Međutim, ako imate mnogo teksta koji želite da unesete i oblikujete, to može zahtevati 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 Visual Basic primer koji pokreće Word, kreira novi dokument i dodaje oblikovani tekst u dokument pomoću unapred izgrađene RTF niske.

Više informacija

Da biste kreirali primer projekta, pratite ove korake:

1. Pokrenite Visual Basic i kreirajte novi Standard EXE. Podrazumevano se pravi obrazac pod imenom "Obrazac1".

2. Dodajte CommandButton u obrazac, kliknite dvaput na CommandButton, a zatim dodajte sledeći kôd u događaj 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
   
   
   

3. Dodajte sledeći kôd u odeljak "Opšte 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
   
   

4. Pritisnite taster F5 da biste pokrenuli projekat. Word se pokreće, a zatim se kreira novi dokument koji sadrži oblikovani tekst.

Reference

Za dodatne informacije i uzorke za razvoj Office rešenja posetite sledeće Microsoft veb lokacije:

http://support.microsoft.com/ofd
        
         http://msdn.microsoft.com/office