Intellisence within code behind forms

[crowegreg]

I'm trying to determine why Intellisense is not working throughout my DB. I've compiled and their are no problems. Here is some sample code:

Dim xlApp As Object
Dim wb1 As Workbook
Dim sheetExcel As Worksheet
Dim shapeExcel As Shape

Set xlApp = New Excel.Application
Set wb1 = xlApp.Workbooks.Open(Environ$("USERPROFILE") & "\documents\" & strFileName & ".xlsx")
Set sheetExcel = wb1.Sheets("Auto Submit Calculations")
Set shapeExcel = sheetExcel.Shapes.AddLabel(msoTextOrientationHoriz ontal, 617, 70, 35, 35)



set shapeExcel = nothing
set sheetExcel = nothing
set wb1 = nothing
set xlApp = nothing

The intellisence works on everything except xlApp. I can't determine the simple solution.

[pbaldy]

You're using late binding, so no intellisense.

[pbaldy]

I should have added that you can develop with early binding to get intellisense, then switch to late binding when ready to distribute.