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?

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?