EXCEL formating

I am not sure why this is happening, but I have an app in which I use the following code to format some cells

VB Code:

xlBook = xlApp.Workbooks.Open(strFileName)
            xlSheet = CType(xlBook.Worksheets(1), Excel.Worksheet)
 
            Dim xlRange As Excel.Range = xlSheet.Range("A1:A1")
            xlRange.Font.Bold = True
 
            xlRange = xlSheet.Range("A1:B1")
            xlRange.EntireRow.Font.Bold = True
            xlRange = xlSheet.Range("A2:A2")
            xlRange.EntireRow.Font.Bold = True
            xlRange = xlSheet.Range("A3:A3")
            xlRange.EntireRow.Font.Bold = True

Using this code in vb 2003 works fine, however in vb2005 I can't get it to work. THere are no errors or anything, but when the program is done I see no changes in the excel sheet

anybody has any ideas????

Quote:

---

Originally Posted by morpheus3230

VB Code:

Dim xlRange As Excel.Range = xlSheet.Range("A1:A1")

---

I'm surprised that you can assign an object within the Dim statement. I always thought you had to use Set xlRange = blah. Of course, I'm using Excel 2002. Maybe that makes a difference.