View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anne Troy[_2_] Anne Troy[_2_] is offline
external usenet poster
 
Posts: 221
Default 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?