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????
