Solved

moving tabs in header and footer word vba

Posted on 2010-09-22
2
452 Views
Last Modified: 2012-05-10
I have a document that has multiple sections and each section has a header and footer that is independent. I have a macro that resizes the document to A4 (upon request). This resizes the margins, location of the header and footer and the page size. However, the headers and footers have a right-aligned tab in them, and that tab does not get reset.

I need help automating the resetting of the tabs. I am not aware of a parameter within pagesetup that would move the tabs. I have tried recording a macro to do the work but that hasn't done the trick either. On a simple sample document it works fine but with my document (which has bookmarks and center tabs and field codes as well) it doesn't (even though that is where I recorded  the macros). Is there something I am missing?
0
Comment
Question by:karimjohnson
2 Comments
 
LVL 3

Accepted Solution

by:
DEVLitehouse earned 500 total points
ID: 33739962
You can get to the TabStops is a member of the Paragraph, ParagraphFormat and Paragraphs classes. As an example, if you want to clear ALL tabstops in a document, you could do this:

Me.Paragraphs.TabStops.ClearAll

I hope this helps you get your exact functionality.  :)
0
 

Author Closing Comment

by:karimjohnson
ID: 33740458
thanks for the advice. I ended up using bookmarks in each section to move between them, then set specific rules for header/footer changes for each section. That worked perfectly.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Nice table. Huge mess. Maybe this was something you created way back before you figured out tabs or a document you received from someone else. Either way, using the spacebar to separate the columns resulted in a mess. Trying to convert text to t…
Shortcuts in Word Just the other day I had a training for Microsoft and they wanted me to show how well the new Windows and Office behaved on a touch device, which by the way is great, but it was only then that I realized that using keyboard shortc…
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question