Help with Book-Marked docs and Excel

[Anna007]

I have the following and I get an error:

Mydoc2.Bookmarks("Equip_TotalPrice").Range.Text = Worksheets("Price").Range("ProposedEqptSellingPrice").Value

My doc is book-marked and I need to grab the appropriate value from Excel and put it into the Book-Marked Field.

Need help asap please...

Thanx,
Anna

 

[PHV]

I get an error
Any chance you could post the whole error message, the highlighted code when in debug mode, which VBA you use (word, excel, ...), how is Mydoc2 instantiated, ....

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[fumei]

Yes, please post code. Note, if you are reusing a bookmark in Word, ifyou are not careful when you insert Range.Text it will; insert the text, but DELETE the bookmark.

Gerry

 

[Anna007]

Hi,
Thank you but I have got it working fine now.
Thanx anyways,
Anna