Solved: VBA Transfering data from excel into a word document.

[iamthebest]

thanks new thread posted in Word forums since now its a word question.

EDIT: This original post has been deleted by iamthebest the original question stated it was university assignment work where the question was to split the word "Quote" from a string "This is a quote...." from several lines, originally code was asked for to perform the task

[Simon Lloyd]

Just a note: I dont expect the answer to be given straight out to me, any guidance will help alot though.

Thats good as we have a policy here on giving help with assignments or homework!

That said you need to post what code you have to show you have actually worked on it.

You might want to explore the worksheet function MID, and it would look like this: =MID(A1,11,5) i will let you fathom out why the figures and what they do, you can call on a worksheet function in vba, you could also look at the VBA "Like" and Option Compare Text, there are quite a few ways to do what you need, try exploring the help files.

[iamthebest]

Finished the first part =) thanks. now the bookmark problem remains.

[iamthebest]

thx

[Simon Lloyd]

iamthebest, now that you have deleted your first post this thread makes no sense, please do not do this again!!!

[lucas]

And where is the link to the word forum thread?

[Simon Lloyd]

This is it...no relation between the two and he doesn't mention that its a university assignment! iamthebest's word thread