Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Source data extract from OLEobject in Excel with VBA

0

Dear Exprts,

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 from the word file. I recorded a Macro but it only pastes data from the clip board and not from the source data. 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

Range("A1").Select
ActiveSheet.Paste
Application.CutCopyMode = False
excelmacros-vba
MS Office Version: 2010
posted by: heg_raj on Wed Apr 19, 2017 at 1:25 am
Answer
Discuss

Discussion

I suggest you do this the other way around. Open the source document in Word, load an instance of the Excel application and paste the table from Word into the Excel sheet.
Variatus (rep: 4889) Apr 19, '17 at 6:38 am
Thanks for your suggestion Variatus. Wondering if you have any code in these lines that I can refer to/use. Highly appreciate your help! Cheers
heg_raj Apr 19, '17 at 7:17 am
You might google for something like "VBA open Excel workbook from Word". With that, or similar, you should find plenty of code to start you off. Ron de Bruin, Contextures or C.Pearson are reliable names, if you come across them in your search.
Variatus (rep: 4889) Apr 19, '17 at 7:59 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login