Dear Experts,

I need to import some word files with (embedded excel) charts into excel and then extract the source data (paste it in excel). I have been able to do the 1st part. But I haven’t been able to extract the source data. I recorded a Macro but it only pastes data from clip board. Any help here is highly appreciated. Thanks heaps – Raj

But the following code for extract and pasting data is not working.

ActiveSheet.OLEObjects(“Object 1”).Verb xlPrimary

Application.CutCopyMode = False

By: rajesh

Leave a Reply

Your email address will not be published. Required fields are marked *