473,811 Members | 3,811 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

VBNET2008 Set Excel 2003 specific Row BackGround color to Yellow

126 New Member
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
    0 1052

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

    Similar topics

    25
    12947
    by: Neal | last post by:
    According to the CSS lint at http://htmlhelp.org/tools/csscheck/, "The shorthand background property is more widely supported than background-color." Can anyone point me to, or provide, information on what browsers have difficulty with the non-shortcut methods of setting background properties?
    13
    12540
    by: Gary | last post by:
    I have a table with a form consisting of several checkboxes and I'm wondering if its possible to change the table row background color on mouseover or hover and make it stay that color when the checkbox in that row is selected? Poko
    3
    8830
    by: Roberto Castro | last post by:
    Hello! I have been assigned for the first time an adp Access project and so far I have managed to make the changes needed for some requirements. However, I am struggling to find the place where the application changes the color of the background of a textbox. Here the explanation goes: This is a form bound to an SQL view. The detail section has several fields, one of them being a textbox of name "Type". I checked its
    2
    2192
    by: iforsyth | last post by:
    I'm doing a query against a database table and outputting to Excel via Response.ContentEncoding and Response.ContentType. Something like the code below where dg is a DataGrid control. Response.Clear() Response.ContentType = "application/vnd.ms-excel" Response.ContentEncoding = System.Text.Encoding.UTF8 dg.DataSource = objDR dg.DataBind()
    0
    1321
    by: Tom | last post by:
    Hi I have a ListBox control of my asp.net web page. I want to set the value of the style property of the ListItem to a specific background color. I have tried this but no success: //li is the ListItem object li.Attributes.CssStyle.Add("BACKGROUND-COLOR:","blue");
    5
    3466
    by: DavidB | last post by:
    Greetings I don't know if this is possible, but this group should be able to tell me. I have a webpage with a changing message board (I understand the problems with having changing text, but this was a nice victory over the demand for a scrolling message). The messages are updates on community information. What I would like to be able to do is have the background color (and possibly font color) change based on the Array Index. For...
    1
    16419
    by: ngpost1 | last post by:
    I have a Crystal Reports.Net report being generated from my C# application. I would like to change the background color of the details section (not the text mind you) of the report on certain conditions. For example if the value of the 'Meeting Number' is greater than 100 the background color of the details section will be light yellow, otherwise it will be white. There will be multiple records in this reports so one (or a few) detail...
    3
    2750
    by: shapper | last post by:
    Hello, Could someone, please, tell me how to change the background color of div when the mouse is hover it? Thanks, Miguel
    2
    2031
    by: bsrcss | last post by:
    I added a 3 column lists to my site using the techniques shown on http://www.communitymx.com/content/article.cfm?page=1&cid=27F87 I first tried their code by itself and it worked fine. When I merged it into my own, it worked fine with Firefox and Safari but not on IE 7. IE7 displayed the 3rd column but the first two columns were not shown. I was able to reproduce with the original small test by adding a background-color statement to...
    3
    10565
    Frinavale
    by: Frinavale | last post by:
    Hi there, I'm using JavaScript to highlight a row or column in a table. I have created a CSS class that changes the background colour to a light blue and I apply this class to the cells in the selected row/column. It works great most of the time but sometimes the cell may have an inline style sets background colour to yellow. This, of course, overwrites the background colour in the class that is being used to highlight the cell. ...
    0
    9724
    marktang
    by: marktang | last post by:
    ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
    0
    9604
    by: Hystou | last post by:
    Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
    0
    10644
    Oralloy
    by: Oralloy | last post by:
    Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
    0
    10379
    jinu1996
    by: jinu1996 | last post by:
    In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
    1
    10394
    by: Hystou | last post by:
    Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
    0
    9201
    agi2029
    by: agi2029 | last post by:
    Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
    0
    5552
    by: TSSRALBI | last post by:
    Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
    0
    5690
    by: adsilva | last post by:
    A Windows Forms form does not have the event Unload, like VB6. What one acts like?
    1
    4336
    by: 6302768590 | last post by:
    Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

    By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

    To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.