Hello,
Glad to know this forum exist. I'm new here and in VBA for Excel.
Hello,
Glad to know this forum exist. I'm new here and in VBA for Excel.
Hello komp.serve,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
thanks arlu1201.. a question:
Is there any solution exist on
' exporting cell value from multiple worksheet in a workbook" into a variable in word so i can place the variable anywhere in word doc?"
I searched the forum but no success. What I'm looking or getting help is. I have a multiple data in multiple column in a multiple sheet that I want to paste into a word doc..let says
data1-10 from worksheet1, value or content (mostly string) of cell A1 to A10
data 11-12 from worksheet2, value or content (mostly string) cell C4 to C5
and the content of these cells paste into a new word document and place it in a table (10 rows 5 columns) with vairables
word table format:
column 1
item1. <data1> 'variable define in word' and data/value or content from cell A1 paste into this variable
item2. <data2> 'variable define in word' and data/value or content from cell A2 paste into this variable
column 2
item1. <data11> 'variable define in word' and data/value/content from cell C4 (from worksheet2) paste into this variable
item2. <data12> 'variable define in word' and data/value or content from cell C4 (from worksheet2) paste into this variable
column 3
item1. <data3> 'variable define in word' and data/value or content from cell A3 paste into this variable
item2. <data11> 'variable define in word' and data/value or content from cell C4 (from worksheet2) paste into this variable
....
....
thanks and more power to this forum..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks