+ Reply to Thread
Results 1 to 2 of 2

VBA- Word import to Excel: Format issue

  1. #1
    Registered User
    Join Date
    02-03-2021
    Location
    London
    MS-Off Ver
    2013
    Posts
    2

    VBA- Word import to Excel: Format issue

    Hi,

    I am using this function to import a word table to excel:

    Please Login or Register  to view this content.

    The problem is that some cells are imported and converted to Date (i.e ''01-10'' become 10-January) and some cells are splitted and not kept merged. Do you know a better code to keep the same format?

    Thank you

  2. #2
    Registered User
    Join Date
    02-03-2021
    Location
    London
    MS-Off Ver
    2013
    Posts
    2

    Re: VBA- Word import to Excel: Format issue

    Attachment 716762

    This is a capture for the reference to my issue. thanks

+ 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. Replies: 3
    Last Post: 01-09-2021, 04:51 PM
  2. Import*a*Particular word*from the word document to*a*excel *
    By shyampanda in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-12-2019, 02:01 AM
  3. Vba to import sets of data from word to excel (the data has a particular format)
    By Story11 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-06-2015, 02:38 PM
  4. how to import word document into Excel - multiple word pages
    By Jissenka in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-22-2015, 12:24 AM
  5. [SOLVED] Import Word.doc into Excel
    By CP in forum Excel General
    Replies: 1
    Last Post: 08-22-2006, 11:00 AM
  6. Hom do I import a word doc. into excel?
    By Big Abalone in forum Excel General
    Replies: 0
    Last Post: 05-12-2006, 01:10 PM
  7. Import cells from excel into word and create multiple word docs
    By scdaddy7269 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2006, 03:03 PM

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