opening a excel from word macro by getting the file name from word at runtime

[Kalsrini]

Hi,

How to open a excel file from word macro by getting the file name from word.
this is my code

OrgFileName = Selection.Text + ".xls"
'OpenExcel Macro
Shell ("C:\Program Files\Microsoft Office\OFFICE11\excel ""C:\My Documents\File - CopyBook\""" + OrgFileName)

OrgFileName is the workbook name which i have to get from word document

Thanks
Kalpana :-)

[aktharshaik]

Plz check out the following attached file.

[Kalsrini]

Hi Shaik,
Thanks for your help.

Regards,
Kalpana

[aktharshaik]

Plz mark the thread as solved.