Open a Excel File from Word

[nkg6971]

Hello All,

How can a excel file is open from ms word through a code ? Kindly advised.

Thanks

[kadghar]

Hello All,

How can a excel file is open from ms word through a code ? Kindly advised.

Thanks

This question has already been answered in other threads, anyway:

[CODE=vb]dim obj1 as object
set obj1 = createobject("e xcel.applicatio n")
obj1.visible=tr ue
obj1.wokbooks.o pen("c:\mybook. xls")[/CODE]

will do.
Remember that if you use some macro recorded with excel in your word's VBA, the xl constants wont work. search in the object browser (F2) or while debuging the code for its numeric value.

HTH

[werks]

Hello All,

How can a excel file is open from ms word through a code ? Kindly advised.

Thanks

I'm a bit confused with your question nkg6971. Correct me if I'm wrong but you want an Excel file be open using MS Word codes???

[kadghar]

I'm a bit confused with your question nkg6971. Correct me if I'm wrong but you want an Excel file be open using MS Word codes???

well that's a good question, and some clarification might be needed...

but since this is a VB forum, i'll assume it's a VBA question.

[werks]

Please post your feedback nkg6971 so we can help you..

--
Kenneth
"Better Than Yesterday"

[nkg6971]

well that's a good question, and some clarification might be needed...

but since this is a VB forum, i'll assume it's a VBA question.

Thanks Kadghar, I have got the solution as the code given by you.