+ Reply to Thread
Results 1 to 3 of 3

Please delete

  1. 01-15-2020, 06:37 PM #1
    marspball
    marspball is offline
    Registered User
    Join Date
    01-08-2020
    Location
    canada
    MS-Off Ver
    windows 10
    Posts
    1

    Please delete

    Please delete
    Last edited by marspball; 01-16-2020 at 10:47 AM.
    Reply With QuoteRegister To Reply
  2. 01-15-2020, 07:27 PM #2
    Marc L
    Marc L is offline
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: How to Speed Up VBA Macro to Import Data from MsWord to Excel

    Hi,

    it's slow 'cause your code not imports data but pilots Word like a human operating manually !
    Importing text files directly under Excel should run faster …
    Reply With QuoteRegister To Reply
  3. 01-15-2020, 10:46 PM #3
    macropod
    macropod is offline
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: How to Speed Up VBA Macro to Import Data from MsWord to Excel

    Cross-posted (and largely answered BEFORE posting here) at: https://stackoverflow.com/questions/...-word-to-excel
    Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to avoid cell SELECTION but still format cells to speed up the macro running speed
    By BeefyBerts in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-05-2018, 08:18 AM
  2. populate listbox in userform in MSword with excel data
    By dreojs16 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-15-2015, 10:32 AM
  3. Converting MSWord Title Case macro to work in Excel
    By jerrydiaz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-12-2014, 11:50 AM
  4. macro to import all but 1st row of data to excel from web
    By fgan79 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2013, 05:12 PM
  5. [SOLVED] Import Data Excel Macro
    By [email protected] in forum Excel General
    Replies: 2
    Last Post: 08-16-2006, 09:55 AM
  6. [SOLVED] Macro target to MsWord
    By Param in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-20-2006, 11:25 AM
  7. re: vlookup in a msword macro returning an error
    By HeatherO in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-06-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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1