Hi,
Try something like this. It will create a new workbook and save it in the
root of drive C:.
Dim myExcel As New Microsoft.Office.Interop.Excel.Application
Dim wb As Microsoft.Office.Interop.Excel.Workbook
wb = myExcel.Workbooks.Add()
wb.SaveAs("C:\test.xls")
wb.Close()
myExcel.Quit()
--
Hope that helps.
Vergel Adriano
"Mansour" wrote:
Dear Friends,
I'm developing a VB.NET 2005 project in windows VISTA.
I add reference to Excel 11 (2003) type library.
My reference seems to be made to Excel.exe and declaration appears as below:
Dim myExcel As Microsoft.Office.Interop.Excel.Application
but it returns exception when I try to cast excel into it as below:
myExcel = GetObject(, "Excel.Application") or myExcel = GetObject(,
"Excel.Application.11")
If I change my delaration to
Dim myExcel As Object
everything goes well for a while but I cannot access most of Excel object
library's properties (such as Activeworksheet.cells(2,2).value) which were
all visible to me in VB6.
Any help would be highly appreciated.
Kind Regards,
M. Ramezani