Copy data from Excel and paste it in a table in word document
I need to copy set of cells from Excel and paste in a word doc in atble format.
ex: iam copying data of 3 rows having 3 columns in excel and want to paste it in a word table.
i tried of of copying excel to word with the following code and worked well but want to insert a table in this word to have this data.
could someone help me out
Dim varDoc As Object
Set varDoc = CreateObject("Word.Application")
varDoc.Visible = True
varDoc.activedocument.SaveAs Filename:="test1" & ".doc"
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1