current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 1 down vote favorite

I'm copying a table from Word then pasting the copied table in an Excel file:

tbl.Range.Copy()
oSheet.Activate()
rng = oSheet.Range("A1")
rng.Activate()

rng.PasteSpecial(Excel.XlPasteType.xlPasteAll)

But when I do this, the table is pasted as a picture. Can anyone please help me with this?

share|improve this question

1 Answer 1

up vote 0 down vote

Check out this answer which explains how to export MS Word tables to Excel sheets. It may provide you with the way forward....

Macro to export MS Word tables to Excel sheets

share|improve this answer
    
Thanks Sam but is there anything non-macro? so that I don't have to create a storage file for it? –  XeL Jun 7 at 0:41
    
Do you mean an assembly? Like an EXE? You could transpose that code to VB.NET and use use the Office interop libraries to perform the same actions that are available in VBA.... –  Sam Makin Jun 9 at 13:47
    
i don't get it.. can you please explain it more further for me?? thanks.. –  XeL Jun 11 at 3:51

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.