Results 1 to 4 of 4

Change language

Threaded View

  1. #1
    Registered User
    Join Date
    01-11-2017
    Location
    London, England
    MS-Off Ver
    2003,2007,2010,2013
    Posts
    65

    Lightbulb Change language

    Hello,

    i'm seeking to modify the attached macro to change the language to in all slides to numbers only, this macro scopes all slides and shapes and changes the language for all text to be English US

    i just want it to scope all numbers only


    attached two sample files for before and after case.

    in before file you will find all text with numbers in English South Africa language

    in after file you will find all numbers set to English US and text still in English South Africa


    Sub SetLangUS()
    Dim scount, j, k, fcount
    scount = ActivePresentation.Slides.Count
    For j = 1 To scount
    fcount = ActivePresentation.Slides(j).Shapes.Count
    For k = 1 To fcount 'change all shapes:
    If ActivePresentation.Slides(j).Shapes(k).HasTextFrame Then
    ActivePresentation.Slides(j).Shapes(k).TextFrame _
    .TextRange.LanguageID = msoLanguageIDEnglishUS
    End If
    Next k
    fcount = ActivePresentation.Slides(j).NotesPage.Shapes.Count
    For k = 1 To fcount 'change all shapes:
    If ActivePresentation.Slides(j).NotesPage.Shapes(k).HasTextFrame Then
    ActivePresentation.Slides(j).NotesPage.Shapes(k).TextFrame _
    .TextRange.LanguageID = msoLanguageIDEnglishUS
    End If
    Next k
    Next j
    End Sub



    cross-posting link: here
    Attached Files Attached Files
    Last edited by Ethen5155; 01-13-2019 at 06:59 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Change Language
    By Dummy99 in forum Excel General
    Replies: 4
    Last Post: 05-03-2016, 08:54 AM
  2. Change Excel Language?
    By Drus in forum Excel General
    Replies: 4
    Last Post: 04-19-2015, 02:03 PM
  3. Change Button language according to Language Settings
    By Meithom in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-02-2015, 05:00 AM
  4. How to change main language?
    By ADB in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-11-2009, 02:12 AM
  5. [SOLVED] How can I programatically change the language in the language bar?
    By Roy Barr in forum Excel General
    Replies: 0
    Last Post: 03-14-2005, 06:06 PM
  6. [SOLVED] How can I programatically change the language in the language bar?
    By Roy Barr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2005, 06:06 PM
  7. [SOLVED] How to change the excel format from language to language?
    By zee in forum Excel General
    Replies: 2
    Last Post: 01-30-2005, 03:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1