PB macros for Word 2010 & 2007
Comments
-
If you know how to code or write macros for automation of the creation of Personal Books, but utilize this coding in other programs such as OpenOffice, Libre Office, Google Docs, whatever... you can write the macros for the automation in those programs, save the completed and formatted document as a .doc, and then open it in Office 2007/2010 to save as a .docx
This is what I have been doing since I have formatting macros that only work in Office 2003.
0 -
Mike S. said:
Bad news: Office for Mac 2011 does not support adding or editing ribbon content, only customizing" (i.e. show/hide)
So, will it work in Office for Mac 2011? How functional is it?
Thanks.
0 -
Thanks! I've been eying this and finally got around to installing it.
0 -
Thanks for making this available to all!
Lenovo P72: Intel 8th Gen i7-8750H 6-core, 32GB RAM, 2TB HDD + 1TB Sata SSD, 17.3" FHD 1920x1080, NVIDIA Quadro P600 4GB, Win 10 Pro
0 -
Kolen Cheung said:Mike S. said:
Bad news: Office for Mac 2011 does not support adding or editing ribbon content, only customizing" (i.e. show/hide)
So, will it work in Office for Mac 2011? How functional is it?
Thanks.
The core functions all work, the verse selector does not work, but could likely be updated to make it work just fine.
As a related note, while I cannot get the macros to show up in a custom or existing ribbon, I do have a custom floating toolbar that works just fine with all the relevant macros. If anyone needs details beyond what Steve has already posted, please post and I'll respond.
0 -
Let me once again say that these macros have been awesome. They keep me from having to remember the exact format and work great!
I just discovered how to assign a keyboard shortcut to the macros making them even easier to apply. Go to customize the ribbon, Lower left click on Keyboard shortcuts, select "Macros" on the Left and on the right select your macro. Put the cursor in "select Keyboard shortcut". Press the keys you want to use as your shortcut.
0 -
Hi Steve
Thanks again for the macros etc. Have run into one problem with a macro security message in Word 2010. Says the macro cannot be found or has been disabled because of your macro security settings. Have checked in Word 2010 & all my macro settings in Options/Trust Centre\trust centre settings are enabled. Is there something I'm missing here? Kind regards, Gerald
0 -
Gerald Rodgers said:
Have run into one problem with a macro security message in Word 2010.
Please check your email.
0 -
steve clark said:
i have added another macro to the set of macros, HyperLink L4Filename. i used it while making a PB with all my document links (see this post).
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.
EDIT (updated for URL fix earlier too) 1104.L4_PB_Macro.zip
Thank you so much Steve!
I first saw this when you first started posting ... but didn't have Word 2010. I finally purchased it and added your macros!
WOW... thank you so much for sharing your talents!
[8-|]
Every Blessing to you and your household of faith!
0 -
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?
Eating a steady diet of government cheese, and living in a van down by the river.
0 -
Doc B said:
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 said: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 said: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.0 -
steve clark said:
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!
Eating a steady diet of government cheese, and living in a van down by the river.
0 -
steve clark said:
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
Eating a steady diet of government cheese, and living in a van down by the river.
0 -
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...????
0 -
Hi Joshy, welcome to the Forum!
Joshy said: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.
0 -
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)?
0 -
Fr Devin Roza said:
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.).
0 -
Thanks for clearing that up, and for the warning! [:)]
0 -
Fr Devin Roza said:
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
to manually add the macros to a new Ribbon in Word.0 -
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
0 -
Hi Donovan,welcome to the Forum!
Donovan Smith said: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)
0 -
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?
0 -
Gary Pajkos said:
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.
0 -
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: [[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 If0 -
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 IfThanks again for reporting this!!!
0 -
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!!![:D]
0 -
Thank you Steve.
This will help me a lot.
0 -
steve clark said:
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)
0 -
bump for those not on the forum this weekend
See this prior post for updated PB Macros
0
