Opening Excel within Word

Hi all,

I am trying to open Excel within a word macro that I am creating, but have been unsuccessful so far.

Here is the current code that I have in the Word VBA window:

Please Login or Register  to view this content.

When running, I get the message "Class does not support automation or does not support expected interface."

Also, I enabled "Microsoft Excel 14.0 object library" in the references...I am using office 2010.

Any suggestions?

Thanks!

Hi chicagoland8,

The following is not tested since I don't like to use Early Binding (just a personal preference):
Changes in red:

Please Login or Register  to view this content.

1. Having said that I don't see how your program can work, since you are calling a .xlsx file which by definition does not have any macros in it.
2. Unless you have more than one 'ShowMsg()' macro, the 'Module1.' is not needed.


Here is the code I tested on my machine that worked using Late Binding:

Please Login or Register  to view this content.

Lewis

Obviously, an XLSX file does not have a macro that you can Run. Maybe you meant to open an XLSM file?

Your syntax is off for the Run method as well. See if you can figure out from this Excel example.

Please Login or Register  to view this content.