Results 1 to 3 of 3

Thread: Alignment word vba

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Sep 2005
    Posts
    151

    Alignment word vba

    I am writing a vba code to get the following result.

    Name of the shop(This has to be in the center)
    Address of the shop(This has to be in the center)
    Date(this has to be on the right side of thedocument.

    On click of a button i am creting a word doc with above reults.

    I have written code for this.
    But when i give alignment for date as right then all the above lines also comes to right side.


    And one more thing..
    How can i give border to the document?

  2. #2
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: Alignment word vba

    You need to change the alignment back after if you want it to be what it was before the right alignment.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  3. #3
    I don't do your homework! opus's Avatar
    Join Date
    Jun 2000
    Location
    Good Old Europe
    Posts
    3,863

    Re: Alignment word vba

    Without looking at your code, it seems like you have selected all when changing the alignment!
    I got that from the macro-recorder:
    VB Code:
    1. 'First Line
    2.     Selection.TypeText Text:="Name of Shop"
    3.     Selection.ParagraphFormat.Alignment = wdAlignParagraphCenter
    4.     'Second Line
    5.     Selection.TypeParagraph
    6.     Selection.TypeText Text:="Adress of Shop"
    7.     'Third Line
    8.     Selection.TypeParagraph
    9.     Selection.TypeText Text:="Date"
    10.     Selection.ParagraphFormat.Alignment = wdAlignParagraphRight
    11.     'Next Line"
    12.     Selection.TypeParagraph
    13.     Selection.ParagraphFormat.Alignment = wdAlignParagraphCenter
    You're welcome to rate this post!
    If your problem is solved, please use the Mark thread as resolved button


    Wait, I'm too old to hurry!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width