PB macros for Word 2010 & 2007

Page 3 of 6 (107 items) < Previous 1 2 3 4 5 Next > ... Last »
This post has 106 Replies | 14 Followers

Posts 3578
steve clark | Forum Activity | Replied: Fri, Nov 18 2011 11:42 AM

Praiser:
Thank you so much Steve! 

another satisfied customer...Smile...just joking, but i am glad that you found this useful!!!

Thanks for letting me know that it is useful to you!

QLinks, Bibl2, LLR, Macros
Dell Insp 17-5748, i5, 1.7 GHz, 8G RAM, win 8.1

Posts 2566
Doc B | Forum Activity | Replied: Thu, Jan 19 2012 3:12 PM

I sure wish someone would delete the obsolete files where we could only find the latest one.  Between post to the mistaken correct file and the others, I'm lost.

I also wish there was an instruction sheet or link to instructions on how to add the macros to buttons on the ribbon.  I do not want to lost my custom QA toolbar, etc.

Can anyone point me to these instructions?

My thanks to the various MVPs. Without them Logos would have died early. They were the only real help available.

Faithlife Corp. owes the MVPs free resources for life.

Posts 3578
steve clark | Forum Activity | Replied: Thu, Jan 19 2012 11:19 PM

Doc B:
I sure wish someone would delete the obsolete files where we could only find the latest one.  Between post to the mistaken correct file and the others, I'm lost.

Sorry, this is out of my control. After a few hours an old post cannot be changed (Edited)

But if you go to this specific post you will find the working set of macros.
Also there are some instruction inside the ZIP (along with the macro file itself)
Below is where my browser placed the ZIP file (from the specific post)

 

Doc B:
I do not want to lost my custom QA toolbar, etc.

You can follow the instructions on the First page of the instructions (top file in the ZIP) to install the macro file itself. But you will need special instructions to add the macros to new buttons in Word so that you don't loose your custom QA toolbar.

Doc B:
I also wish there was an instruction sheet or link to instructions on how to add the macros to buttons on the ribbon.

I will attempt to give you the basics.

After installing the macro file per the first page of the embedded instructions....

We will want to open a new Word document using the new Macros (ones you loaded as mentioned above)

1. Click on File

2. Click on New

3. Click on My templates
   a. In the pop-up window locate the macro (L4_PB Macros.dotm) and click on it
   b. Make sure you select Document
   c. Click OK.

Now you should have a new doc open which has the macros enabled.

The next step is to build a new Ribbon with buttons attached to each macro

1. Right-Click in a blank area of the ribbon.

2. In the pop-up menu click on Customize the ribbon

This will open the customization window

There are many steps to add all the macros that i have added. But here are the basics

1. In this selector, find Macros

2. You will need to add a new Tab (this will eventually be your new ribbon).
    Inside the tab you will need to add groups for each type of macros (e.g. Milestones, DataLinks, Fields, etc)

3. You will need to locate the appropriate macro and add it to the appropriate group.
    You will probably want to edit it after adding it to change the button image and text.

If this is too much for you then drop me an email   STEVE at CLARK-TX dot COM
and i might be able to connect to your computer and help you do this.

 

QLinks, Bibl2, LLR, Macros
Dell Insp 17-5748, i5, 1.7 GHz, 8G RAM, win 8.1

Posts 2566
Doc B | Forum Activity | Replied: Sat, Jan 21 2012 2:40 PM

steve clark:
If this is too much for you then drop me an email 

Thanks, Steve, that was helpful.  I have it worked out now.  I don't know if it was the right way, but I was able to use the 'Rename' button on each macro to assign a button to it.  Here's how my set looks-

I think I got one of the earlier-than-final macro sets...so now I'm off to figure out how to replace it.

Sorry you got stuck supporting your macro set.  No good deed goes unpunished!

 

My thanks to the various MVPs. Without them Logos would have died early. They were the only real help available.

Faithlife Corp. owes the MVPs free resources for life.

Posts 2566
Doc B | Forum Activity | Replied: Mon, Jan 23 2012 2:22 PM

steve clark:
Here is a link to watch how to add buttons to the toolbar

Here is a set of instructions that I did myself.  I don't know if this method is better or worse, but it works.

0216.How To Add the L4 Macros to Custom Buttons in Word 2010.pdf

My thanks to the various MVPs. Without them Logos would have died early. They were the only real help available.

Faithlife Corp. owes the MVPs free resources for life.

Posts 1
Joshy | Forum Activity | Replied: Tue, Mar 13 2012 11:02 PM

Thanks a lot for this great tool.

I was trying to use it with word 2007 (win7). I can view the macros. But when I try to run it, i get an error message: "Run-Time error '5173': This style name already exists or is reserved for a built in style." what could be the problem and how to correct it...????

Posts 3578
steve clark | Forum Activity | Replied: Wed, Mar 14 2012 7:03 AM

Hi Joshy, welcome to the Forum!

Joshy:
But when I try to run it, i get an error message: "Run-Time error '5173': This style name already exists or is reserved for a built in style." what could be the problem and how to correct it...????

drop me an email:   ************  (will remove this later this evening)

i may need to connect to your machine to figure this one out.

QLinks, Bibl2, LLR, Macros
Dell Insp 17-5748, i5, 1.7 GHz, 8G RAM, win 8.1

Posts 1438
Forum MVP
Fr Devin Roza | Forum Activity | Replied: Wed, Mar 28 2012 10:24 AM

Steve et al,

Thanks a lot for this tool. Fantastic work.

In theory it should be possible to "Export" your Ribbon customizations, upload that Export file to the forums, and then we can just import the code and then import the customizations. Much simpler! It would be worth a try if you haven't yet.

In the "Customize the Ribbon..." dialog, select the "Import/Export" button on the bottom right and then select "Export all customizations". It will offer to save a file with the extension "exportedUI". Could you post that up here and we can see if we can successfully import it (after importing the code of course)?

Posts 3578
steve clark | Forum Activity | Replied: Thu, Mar 29 2012 9:10 AM

Fr Devin Roza:
In theory it should be possible to "Export" your Ribbon customizations, upload that Export file to the forums, and then we can just import the code and then import the customizations. Much simpler! It would be worth a try if you haven't yet.

This is precisely what i did last year in this post. If you extract the ZIP, you will find an Instruction PDF file. What you may not realize, is that when you Import the UI file, you will loose all other customization. Since many users may not have learned many details of Word outside their normal use, this could cause very unwanted results (e.g. they have installed special driver Add-ins for printers or scanners or what ever other tools they may be using with Word. Then they would be removed when the UI was imported. And they would need to know how to reinstall them.).

 

QLinks, Bibl2, LLR, Macros
Dell Insp 17-5748, i5, 1.7 GHz, 8G RAM, win 8.1

Posts 1438
Forum MVP
Fr Devin Roza | Forum Activity | Replied: Thu, Mar 29 2012 9:28 AM

Thanks for clearing that up, and for the warning! Smile

Posts 3578
steve clark | Forum Activity | Replied: Thu, Mar 29 2012 9:39 AM

Fr Devin Roza:
Thanks for clearing that up, and for the warning!

You are welcome, Just so that anyone reading this far down in this thread...

The instructions inside the zip show you how to save your current UI configuration prior to installing the new one so that in the event that you may have lost any Add-ins or customization, you would be able to restore them. For many users you will not have made any customization and the installation of the new Ribbon will be completely painless.

PS for those who find that they do have customizations, after restoring your UI (per instructions in the PDF mentioned above) you can use the instructions in the post above (by Doc B) to manually add the macros to a new Ribbon in Word.

QLinks, Bibl2, LLR, Macros
Dell Insp 17-5748, i5, 1.7 GHz, 8G RAM, win 8.1

Posts 1
Donovan Smith | Forum Activity | Replied: Wed, Apr 11 2012 6:44 AM

Hi Steve

I am Donovan I just install the macro and its only working for one session at a time with the problem just  Gerald Rodger discribe help please

Posts 3578
steve clark | Forum Activity | Replied: Wed, Apr 11 2012 7:02 AM

Hi Donovan,welcome to the Forum!

Donovan Smith:
I just install the macro and its only working for one session at a time

Are you running Office 2010?

EDIT: perhaps it would be faster to help you if you would email me:  (removed after contact)

QLinks, Bibl2, LLR, Macros
Dell Insp 17-5748, i5, 1.7 GHz, 8G RAM, win 8.1

Posts 105
Gary Pajkos | Forum Activity | Replied: Sun, Apr 15 2012 3:33 PM

I am unable to add the L4_PB_Macro_Tab.exportedUI into my Word 2007.  When I right click on the ribbon and select customize the Quick Access Toolbar, there is no option to customize the ribbon, the pop-up window has no button to click to import the tab file.  

How can I get Word to import this Tab file?

 

Posts 3578
steve clark | Forum Activity | Replied: Sun, Apr 15 2012 4:08 PM

Gary Pajkos:

I am unable to add the L4_PB_Macro_Tab.exportedUI into my Word 2007.  When I right click on the ribbon and select customize the Quick Access Toolbar, there is no option to customize the ribbon, the pop-up window has no button to click to import the tab file.  

How can I get Word to import this Tab file?

You are correct. The macros will load and work in Word 2007, but the UI (user interface ribbon) will not. But you can manually add each macro to the toolbar. If you search Microsoft's website on adding commands to the Toolbar, then you can add each of the macros as a separate command on your toolbar. Since i don't have Word 2007, i cannot show you how to do this. Once i connected remotely to someone's computer and did this a long time ago. They had Word 2007.

 

 

QLinks, Bibl2, LLR, Macros
Dell Insp 17-5748, i5, 1.7 GHz, 8G RAM, win 8.1

Posts 2
Jacobus Stefanus | Forum Activity | Replied: Wed, May 30 2012 1:14 AM

I downloaded the file and think you did an awesome job.

I experience a problem on the "Verse Fragments"  , when I use it on 1 Tim 1:2 the result is as follow: Normal 0 false false false EN-US X-NONE X-NONE [[1 Tim 2:3 >> 1 Tim 12:3]].  I could fixed it by adding the following in your code:

Public Function ExtractChapterVerse(src As String, ByRef dest() As String) As Boolean
    Dim i As Integer, ch As String, s1 As String, s2 As String
    Dim ColonPos As Long, vSrc As String, Fnd As Boolean
   
    'does NOT handle comma separated verses or chapters
    Fnd = False
    ColonPos = InStr(src, ":")
   
    'presume the absence of a colon to be a Verse only
    If ColonPos > 1 Then
        s1 = ""
        For i = 1 To IIf(ColonPos < 1, Len(src), ColonPos - 1)
            ch = Mid(src, i, 1)
            If IsNumeric(ch) = True Then
                If ch = Left$(src, 1) Then
                    ch = " "
                End If

                       s1 = s1 & ch
             End If
        Next i
       
        If s1 <> "" Then
            Fnd = True
        End If
        vSrc = Mid(src, ColonPos + 1)
    Else
        vSrc = src
    End If

Posts 3578
steve clark | Forum Activity | Replied: Wed, May 30 2012 7:21 AM

Hi Jacob,

Welcome to the forum!

Nice find and fix!

Your change will work most of the time, but if there is a leading space or something else before the number and the book name, then your fix will fail. (e.g. 'see 1 Tim 2:3')

Try changing the code to what is shown below. This should fix the problem you found and handle the case which i mentioned above.

    'presume the absence of a colon to be a Verse only
    If ColonPos > 1 Then
        s1 = ""
        For i = 1 To IIf(ColonPos < 1, Len(src), ColonPos - 1)
            ch = Mid(src, i, 1)
            If IsNumeric(ch) = True Then
                s1 = s1 & ch
            ElseIf ch >= "A" And ch <= "z" Then
                s1 = ""

            End If
        Next i
       
        If s1 <> "" Then
            Fnd = True
        End If
        vSrc = Mid(src, ColonPos + 1)
    Else
        vSrc = src
    End If

 

Thanks again for reporting this!!!

 

QLinks, Bibl2, LLR, Macros
Dell Insp 17-5748, i5, 1.7 GHz, 8G RAM, win 8.1

Posts 3292
Francis | Forum Activity | Replied: Wed, May 30 2012 7:51 AM

Thank you Steve: your work is greatly appreciated. I have not had much opportunity to use your macros yet but I have this project of converting and importing into Logos 4 all the papers I have written over the years. I am sure your macro will help. Many thanks again!!!Big Smile

Posts 2
Jacobus Stefanus | Forum Activity | Replied: Tue, Jun 12 2012 9:08 AM

Thank you Steve.

 

This will help me a lot.

Posts 3578
steve clark | Forum Activity | Replied: Sat, Oct 27 2012 12:29 PM

steve clark:
If you already have added my macros earlier you will need to follow the steps in the attached PDF Adding the macros to Word again to: add the macro & add the new Tab. Also the Macro Information PDF has been updated which tells you how to use it.

Update to the Macro for Word 2010.

Added new macro to insert Sermon table

Download -->  L4_PB_Macro_Tab (Oct 27, 2012).zip

Edit: For instructions on how to install these macros & UI, please watch this video:
        (you will need the current Flash plug-in for your browser)
        Installing L4 Macros into Word

 

========================Views from Word 2010=====================================

 

 

(click on image for larger view)

 

========================View of Custom Ribbon in Word 2010=======================

Before updating your Word 2010 with the included UI (User Interface):
    (Please read the Adding the macros to Word.pdf found in the zip)

If you already have Quickaccess tools or a Custom Ribbon, then you may want to manually add the
L4 Macros Ribbon so that you don't loose your current settings.

(click for larger view)


QLinks, Bibl2, LLR, Macros
Dell Insp 17-5748, i5, 1.7 GHz, 8G RAM, win 8.1

Page 3 of 6 (107 items) < Previous 1 2 3 4 5 Next > ... Last » | RSS