Forum Discussion
HKosova
Alumni
13 years agoHi Rama,
You can check if a workbook is open in Excel, and create (or open) the workbook if needed:
Is this what you need?
You can check if a workbook is open in Excel, and create (or open) the workbook if needed:
If msExcel_Report.ActiveWorkBook Is Nothing Then
msExcel_Report.Workbooks.Add
' -- or --
' msExcel_Report.Workbooks.Open(FileName)
End If
msExcel_Report.ActiveWorkBook.SaveAs(NewReport)
Is this what you need?