View Single Post
 
Old 02-28-2015, 10:48 PM
Bedsy Bedsy is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Feb 2015
Posts: 3
Bedsy is on a distinguished road
Question Transfer word doc bookmarks to excel using macro

Hi all,

Could really use some help.

I have a word doc that has several bookmarks. I am trying..... Or to be honest, failing to write the vba to transfer the bookmarks to a specific excel spreadsheet named "register".

Am trying to have the vba find the next blank row in "register" spreadsheet and place the bookmarks in adjacent cells for example.

Bookmark "site" to go in column "a" in excel sheet
Bookmark "company" to go in column "b" in excel sheet and so forth.

Save/overwrite the spreadsheet and than close excel.

Thank guys.
Reply With Quote