Code for Word to Excel spreadsheet

[birth19]

Hi,

I have recently just used this macro for my excel spreadsheet to pull data from all 50+ word document forms within my "Engineer Forms" folder.

For some reason I am receiving a Error 53 : File not found message.

It is pulling the data from one document in my folder but not the rest.

Can someone please assist me on this???

Please Login or Register  to view this content.

[watersev]

hi birth19, the only suggestion is that other files have different file extension. The code processes .doc files but not .docx or .docm. So you may check folder contents regarding file extensions present. If to correct that in the code, you may change this:

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

[birth19]

Hi Watersev,

Thanks for the quick response.

I have tried both of these but I am still getting the error message, all documents are doc extension and the file it's pulling data from isn't even the first document. The only thing that stands out about this document is it is 39kb rather then 40kb that the others are but that can't be the factor.

[mohd9876]

does the folder Logged really exist in the same directory?
if not it will produce file not found error

[birth19]

Yes it is all in the same directory.

[mohd9876]

could you set a break point and see which line gives the error?

[snb]

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.