Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 06-21-2023, 10:36 PM
Guessed's Avatar
Guessed Guessed is offline Help with debugging a simple macro to cut and paste selected text to end of document Windows 10 Help with debugging a simple macro to cut and paste selected text to end of document Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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
Reply With Quote
  #17  
Old 06-21-2023, 11:43 PM
teachwrite teachwrite is offline Help with debugging a simple macro to cut and paste selected text to end of document Windows 11 Help with debugging a simple macro to cut and paste selected text to end of document Office 2021
Novice
 
Join Date: Jun 2023
Posts: 3
teachwrite is on a distinguished road
Default

That works beautifully for creating the style sheet in the first instance, but it errors when trying to add additional selected text to the same style sheet. Is that an easy adjustment?

So, keep the existing functionality (which is spot on), but add that subsequently selected text is added to the end of the open stylesheet.

Thanks for your help! This will save me hours and hours each week!
Reply With Quote
  #18  
Old 06-22-2023, 01:26 AM
Guessed's Avatar
Guessed Guessed is offline Help with debugging a simple macro to cut and paste selected text to end of document Windows 10 Help with debugging a simple macro to cut and paste selected text to end of document Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I don't know what you selected after the first entry but it was working for me.

The code is copying unformatted text content to the StyleSheet docx and I thought it wouldn't matter if you shut it or kept it open.

If it is still throwing an error, can you work out what line it is failing on?
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #19  
Old 06-23-2023, 12:21 PM
dfuent1321 dfuent1321 is offline Help with debugging a simple macro to cut and paste selected text to end of document Windows 10 Help with debugging a simple macro to cut and paste selected text to end of document Office 2021
Novice
Help with debugging a simple macro to cut and paste selected text to end of document
 
Join Date: Oct 2022
Posts: 7
dfuent1321 is on a distinguished road
Default

Thanks for this solution. Someone else offered a solution earlier that worked, so I'll just keep using it. But I truly appreciate the help!
best,
David
Reply With Quote
  #20  
Old 06-25-2023, 03:20 AM
Guessed's Avatar
Guessed Guessed is offline Help with debugging a simple macro to cut and paste selected text to end of document Windows 10 Help with debugging a simple macro to cut and paste selected text to end of document Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,977
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Looking back at the code I supplied, I expect it would error if the StyleSheet was already created but closed again and then the macro was run. I should have added a test to make sure the file didn't already exist before trying to save a new file over the top of it (by opening the existing style sheet instead of creating a new doc).

Since you already have a working replacement I won't bother fixing that problem in the code above.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #21  
Old 08-03-2023, 02:32 PM
GDA63378 GDA63378 is offline Help with debugging a simple macro to cut and paste selected text to end of document Windows 10 Help with debugging a simple macro to cut and paste selected text to end of document Office 2019
Novice
 
Join Date: Aug 2023
Posts: 5
GDA63378 is on a distinguished road
Default

Nevermind this post. Can't find out how to delete, so I've edited.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with debugging a simple macro to cut and paste selected text to end of document Keep text selected after paste dabbler Word 14 01-11-2021 09:54 AM
Help with debugging a simple macro to cut and paste selected text to end of document 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
Help with debugging a simple macro to cut and paste selected text to end of document Find and Replace Selected Text or Macro for finding selected text mrplastic Word VBA 4 12-20-2019 01:25 PM
Help with debugging a simple macro to cut and paste selected text to end of document Help debugging a Macro that merges individual word docs into one document vincenzo345 Word VBA 4 12-01-2017 11:25 AM
Help with debugging a simple macro to cut and paste selected text to end of document Macro (debugging) JACKsparrow Word VBA 1 03-09-2016 02:47 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:15 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft