Opening an excel document

[amars]

Hi all,

I am exporting an excel sheet using a macro like this

set obj = ActiveDocument.GetSheetObject(ExcelID)

obj.ExportBiff reportFile & ".xls"

reportFile = reportFile & ".xls"

I want to open the excel file after it is being exported. How to do it in a macro?

Thanks in advance

Regards

Amar

[biester]

Hy amar,

you could do it this way:

Set objExcel = CreateObject("EXCEL.APPLICATION")
Set objWorkBook = objExcel.Workbooks.Open(reportFile)
objExcel.Visible = True

Rgds,
Joachim