I've been searching the web for quite some time now, but i cant find it.
My skills: Limited ( first time using vba,, but search the web for hours, so i know some basic stuff what i've read)
My programs: Office 2010
I have an map full with .doc files and want to convert them to excel files.
The word file
has an table in it with data, This data is from machine specs, and i want to import them in to an excel database.
I thought the best thing is save / export the word table to an excel file.
And later on make an (master) excel file and link the seperate files to this master file.
I've got an working
macro to import table dat from word in to an excel spreadsheet (found it on the web)
But it is limited to one file ( i've got 200/300 files so it would be easy i've vba can do it for me )
New Text Document (6).txt
I want to automate the proces and let it save the workbook automaticly
And this code only get cells 3,2 and 4,2
I want many more ranges and data cells, these i've already got sorted in another excel file so i can copy them real quick
But it needs an additional bit that overrules the empty cells ( i've pasted my ranges and cells in the macro ) and that
works, but i get an error on every empty cell ( i dont have that basic knowledge )
I think you guy's can help
So please do so.
To make the macro working i've changed Dim wdDoc As Word.Document
the Word.Document to Object.