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