By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,747 Members | 1,808 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,747 IT Pros & Developers. It's quick & easy.

VBNET2008 Set Excel 2003 specific Row BackGround color to Yellow

100+
P: 126
Hullo Good Friends,
I am using VBNET2008 and Excel 2003.
I need your help. Please help me.

I am trying to develop coding to specific set the Excel 2003 Row BackGround Color to Yellow and it's not working as I have not done it before logically.

Here is the coding that is not working:
Expand|Select|Wrap|Line Numbers
  1. xlWrkSheet.Rows(intRow).BackGroud.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Yellow)  
Here are part of the overall Coding:
Expand|Select|Wrap|Line Numbers
  1. Dim xlExcel As Excel.Application
  2. Dim xlWrkBook As Excel.Workbook
  3. Dim xlWrkSheet As Excel.Worksheet
  4. Dim xlRange As Excel.Range
  5. Dim oMissing As Object = System.Reflection.Missing.Value
  6.  
  7. Dim intRow as interger = 5
  8. xlWrkSheet.Rows(intRow).BackGroud.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Yellow) 
  •  
  • Please help me with sample working coding. I will learn new logical technic from it.

    Thank You,

    Cheers,
    Lennie
    Jan 17 '11 #1
    Share this question for a faster answer!
    Share on Google+

    Post your reply

    Sign in to post your reply or Sign up for a free account.