View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] kylancal@gmail.com is offline
external usenet poster
 
Posts: 2
Default 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?