Convert Word Table to Excel via web page

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Eltonlaw

Thread Starter
Joined
Feb 2, 2011
Messages
1
Dear expert,
Needs to convert Word table (data) to Excel.
Using copy/paste does not work well as format are totally gone.
Have learnt to use:
1. For Word file, save as web page. Then close the word and file.
2. In Excel, Under Data menu, use Import External data, then import Data.
3. Choose the .mht file I have saved in Word.
4. New Web Query will pop up and choose options - check "FULL HTM Formatting to do conversion", check "USe the same import settings for the entire section"
5. Press import button and export to Cell A1
But the problem is ....
This still involves a lot of manual steps to do if there are a lot of files to be done.
Is it possbile to write the VBA in Word or write the script in Excel to do all the steps above?
Doc files in C:\Temp\Word\
Web files in C:\Temp\Web\
Excel files in C:\Temp\Excel\
Thanks for help.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top