+ Reply to Thread
Results 1 to 2 of 2

Inserting text from external TXT (UTF-8) file between slides, macro modification

  1. #1
    Registered User
    Join Date
    05-29-2020
    Location
    Wroclaw, Poland
    MS-Off Ver
    2019
    Posts
    1

    Question Inserting text from external TXT (UTF-8) file between slides, macro modification

    I have a list of Polish words written exactly like this in the txt file:
    arbuz
    bąk
    chór
    cielę
    ćma
    dłoń
    dżdżownica
    dżungla
    dźwig

    I wish:
    1. that there be a separate slide on each of these words
    2. that the slides are created between already existing slides (1. old slide - new slide "arbuz", 2. old slide - new slide - "bąk", 3. old slide - new slide "chór", etc.)
    3. that each word is in the middle of the slide
    4. so that I can define the same font size every new slide should have the same font I defined)
    5. it would properly import Polish characters


    I found this macro:
    Please Login or Register  to view this content.
    Unfortunately, it only meets conditions 1) and 3). Moreover, it does not support Polish characters (UTF-8). How can I modify this macro?

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,972

    Re: Inserting text from external TXT (UTF-8) file between slides, macro modification

    To read UTF-8 char set, you'd need to use ADO.Stream.

    Ex:
    Please Login or Register  to view this content.
    Try incorporating this into the code. I don't have time for rest of your issue at the moment. It would help, if you can upload sample along with desired result (zipped).
    "Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
    ― Robert A. Heinlein

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] String manipulation & modification in a TEXT file.
    By webwyzard in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-30-2018, 11:35 AM
  2. Need help fixing a macro which fills power-point slides from excel file
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2017, 11:44 PM
  3. Need Code Modification for Text file to Excel File
    By pvsvprasad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2016, 12:55 PM
  4. VBA macro for Inserting text file(having pipe as delimiter) into Excel sheet
    By Nusrat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-26-2013, 05:40 AM
  5. Need Macro Modification for inserting a row and filling down formulas
    By Prophet Warrior in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-28-2013, 05:03 PM
  6. [SOLVED] Slight Modification Request VBA Code - Text File to Excel
    By spiwere in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 03-22-2013, 04:39 AM
  7. Macro to check for file modification and display a pop-up or reload the client file.
    By Askander in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-02-2011, 09:26 AM

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