Accessing Excel From Word

[Carolyn Speakman]

Hi,

I'm fairly new to VBA and I'm trying to open Excel from word but it's not working. I'm using Office 2003, and this is the code:

Dim excelTemp As Object
Set excelTemp = CreateObject(Excel.Application)

I've also tried declaring excelTemp As Excel.Application, but it's not recognised as an object type.

Anyone got any ideas??
Carolyn

 

[Jonathan West]

Hi,

I'm fairly new to VBA and I'm trying to open Excel from word but it's not

working. I'm using Office 2003, and this is the code:

Dim excelTemp As Object
Set excelTemp = CreateObject(Excel.Application)

I've also tried declaring excelTemp As Excel.Application, but it's not recognised as an object type.

Anyone got any ideas??
Carolyn

Hi Carolyn

Take a look at this article

Control Excel from Word
http://word.mvps.org/FAQs/InterDev/ControlXLFromWord.htm

 

[cisco kid]

hi - I think you are missing the quotes around Excel.Application
ie Set excelTemp = CreateObject("Excel.Application")

 

[Chad DeMeyer]

Or if you use the early binding method (i.e., declaring excelTemp as
Excel.Application), you must add a reference in your project to the
Microsoft Excel 11.0 Object Library, using Tools>References.

Regards,
Chad