[RESOLVED] Reading Excel sheet in VB, need to read the leading zeros

[Static]

well tha would make sense.. intellisense probably doesnt show u anything because of how u are declaring it

Dim ObjInputRefWorkBook As Object
Dim ObjInputRefSheet As Object
Dim objRefSheet As Object

if u add a reference to MS Excel x.0 Object Library and change the references to this

DIm ObjInputXLS as Excel.Application
Dim ObjInputRefWorkBook As Workbook
Dim ObjInputRefSheet As Worksheet
Dim objRefSheet As Worksheet

Set ObjInputXLS = New Excel.Application

that will give u all the intellisense...
now. 1 issue with this is that its not as compatible.
if u use this method (Early binding) then people with earlier versions of excel wont be able to use this.

so.. here is what I do.

Program this way.. get everything running. then switch it BACK to the object/create object(Late binding) method. (Dont forget to remove the reference)


Another way is to go into excel and program it then move your code over to VB
u can even record a macro to figure out how to do something, then copy the code over. once copied, just add the object reference back in and u are good to go.