![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#14
|
||||
|
||||
|
Try this code
Code:
Option Explicit
Const sSS As String = "StyleSheet.docx"
Sub Send2StyleSheet()
Dim sPath As String, docSS As Document, aRng As Range, rngTarget As Range
Set aRng = Selection.Range
If Len(aRng.Text) > 0 Then
sPath = ActiveDocument.Path & Application.PathSeparator
Set docSS = GetSS(sPath)
Set rngTarget = docSS.Range
rngTarget.Collapse Direction:=wdCollapseEnd
rngTarget.Text = vbCr & aRng.Text
End If
End Sub
Function GetSS(sPath As String) As Document
Dim aDoc As Document
For Each aDoc In Documents
If aDoc.FullName = sPath & sSS Then
Set GetSS = aDoc
Exit For
End If
Next aDoc
If GetSS Is Nothing Then
Set GetSS = Documents.Add()
GetSS.SaveAs FileName:=sPath & sSS
End If
End Function
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Keep text selected after paste
|
dabbler | Word | 14 | 01-11-2021 09:54 AM |
Copy selected text from one document and paste to new document in same position on the page
|
gasparik | Word VBA | 1 | 05-11-2020 05:41 AM |
Find and Replace Selected Text or Macro for finding selected text
|
mrplastic | Word VBA | 4 | 12-20-2019 01:25 PM |
Help debugging a Macro that merges individual word docs into one document
|
vincenzo345 | Word VBA | 4 | 12-01-2017 11:25 AM |
Macro (debugging)
|
JACKsparrow | Word VBA | 1 | 03-09-2016 02:47 PM |