Hi does anyone know how to export selected data from an excel document and insert it in to specific points in a word document, is it even possible? any help appreciated..thanks
Printable View
Hi does anyone know how to export selected data from an excel document and insert it in to specific points in a word document, is it even possible? any help appreciated..thanks
Welcome to the Forums.
Yes its possible but will take a decent amount of code.
To start search the Forums for code examples (there are allot) on accessing
Excel using VB and also for accessing a Word Document. Then we would
merge the two together in a logical sense.
Connect to Excel and read your selected data. Then iterate through the
selected range and write it in the word document at the desired paragraph
or ???
Get the ball rolling and I will guide you on your way :)
Well... i have the same problems. However yhe answer of moderator is terribly beurocratic and gives no information at all. I have looked through the code examples. No solution for this probleme there
Romur, a Moderators duties include overseeing their assigned Forum(s) for
many things like violations of the Forums AUP and secondly, answering
questions.
I post allot of anwers every day, probably one of the top posters, but I dont
think anyone will write an entire program for you if you dont show some
initive first. ;)
After a very quick and simple Search I found several examples that would
help you get started accesing Excel and Word from VB.
These two are the simplest and least cluttered. I would have replied earlier
but the search got so many hits that it took a while to come back from the
server.
Accessing Excel using VB.
Accessing Word using VB.
:)