Excel file location

[ejme]

how do u point the code to your excel sheet?

       objApp = New Excel.Application
        objBooks = objApp.Workbooks
        objBook = objBooks.Add
        objsheets = objBook.Worksheets
        objsheet = objsheets(1)

        objBooks = CreateObject("Excel.Application")

something like application.startuppath???

[jmcilhinney]

You have to pass the path of the file to to the Workbooks.Open method. If your file is in your program folder then you can use Application.StartupPath to build that path. Application.StartupPath is just a property and it retruns a string containing the path to the folder from which the current application was run. If you want to get the path to the file Workbook.xls in your program folder then use:

Dim filePath As String = IO.Path.Combine(Application.StartupPath, "Workbook.xls")

If your app was run from "C:\Program Files\MyApp" then filePath will contain "C:\Program Files\MyApp\Workbook.xls".