Trying to open Excel From Visual Basic 2005

K

kylancal

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot open dbf file created in Visual Foxpro 7 or 9 in EXCEL 2010 0
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
VSTO Excel 2003 to VB 6.0 Type Mismatch 1
Excel 2003 - problem using from .Net 2
Runtime Error '7': Out of Memory 3
style propertie causing excel not being released 2
Asking users to Enable Macro's 4
Open Excel file with ASP.Net 1

Top