Excel automation: get sheet and range names

[kareninstructor]

Hi there, I'm struggling with an issue trying to do something similar to what you are doing in this code, so I tried your version and I seem to be getting the same issue.

When stepping through the code, when it gets to this line in the function getInformation xlWorkBook = xlWorkBooks.Open(FileName)

The form frmExcelAutomationGetInfo is displayed on the screen and nothing further happens.

Do you have any idea what might cause this?

There are several reasons for your code not working but as you have not posted any code I am at a lose to make a suggestion to change your code to work.
Best to look at the following article under VB.NET Code bank.which shows how to use Excel automation without showing an instance of Excel. Also included is a small OleDb code example but the majority of the code is Excel early binding. Even thou the code is in a VS2010 project the logic will work in VS2008 also.