Copy data from word to excel - Word VBA

**kumarcoolz** · 11-09-2017, 10:05 AM

I am trying to automate a word template to update an excel sheet. I managed to complete almost 90% of the automate.
However, I am stuck up with a minor problem. The excel sheet is sort of a database which needs to be constantly updated. Hence, I need to identify the last row in the excel sheet.
The code throws up an error "Runtime error 1004" when I run the code.

I wanted to find the valve for y

it will be great if any one can help me out on the bug

Please Login or Register  to view this content.

**macropod** · 11-09-2017, 06:28 PM

Since you're using late binding, you can't use Excel constants; you need to use their equivalent values, thus:

Please Login or Register  to view this content.

There is also no need to activate the worksheet.

Your code has other fundamental problems, which I'm sure you'll now discover...

Copy data from word to excel - Word VBA

LinkBack

Thread Tools

Rate This Thread

Display

Copy data from word to excel - Word VBA

Re: Copy data from word to excel - Word VBA

Thread Information

Users Browsing this Thread

Similar Threads

Extract Word header table data to excel (closed word document)

Excel VBA - Word to search for part of a word and replace full word

VBA Transfer Data From Excel to Word and Keep Bookmarks in Word Documents

How to do this: Excel Data -> Template Word Doc -> Restricted Word (No changes-read only)

Extracting data from excel to word. Different versions of MS Word giving issues.

Copy Many Word Docs to New Word Doc (Each Word Doc Should be on New Page)

[SOLVED] Print labels by using Excel data in a Word mail into word

Bookmarks

Bookmarks

Posting Permissions