Trying to open Excel From Visual Basic 2005
 

I'm trying to open Excel with Visual Basic 2005 with the following
Code

Dim myExcelObj as New Excel.Application
myExcelObj.visible = true
dim wb as Excel.Workbook
wb = myExcelObj.workbooks.add

My problem is that the Excel instance that opens seems crippled it
doesn't have my personal.xls. it doesn't have any stored macros i
have in excel. Does anyone know why opening excel this way causes
this as opposed to opening it manually?

Trying to open Excel From Visual Basic 2005
 

See this TechNet article:
http://support.microsoft.com/default...b;en-us;213489

****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
wrote in message
oups.com...
I'm trying to open Excel with Visual Basic 2005 with the following
Code

Dim myExcelObj as New Excel.Application
myExcelObj.visible = true
dim wb as Excel.Workbook
wb = myExcelObj.workbooks.add

My problem is that the Excel instance that opens seems crippled it
doesn't have my personal.xls. it doesn't have any stored macros i
have in excel. Does anyone know why opening excel this way causes
this as opposed to opening it manually?