Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Manipulating Excel: How to change cell Color 1

Status
Not open for further replies.
mkjp2011

mkjp2011

Programmer
Aug 24, 2010
15
0
0
US
How can I change the background color of one cell within a EXTRA! Basic Macro?
 
Sort by date Sort by votes


Hi,

Post whatever code you already have that instantiates the Excel application object and references an Excel workbook/worksheet.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Upvote 0 Downvote
Set excelReport = CreateObject("Excel.Application")
excelReport.Workbooks.Add
Set objSheet1 = excelReport.ActiveWorkbook.WorkSheets(1)
 
Upvote 0 Downvote


Code: 
Set excelReport = CreateObject("Excel.Application")
Set xlWB = excelReport.Workbooks.Add
Set objSheet1 = xlWB.WorkSheets(1)  

objSheet1.cells(1,1).interior.color = vbred

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

247xavi
  • Locked
  • Question
Attachmate to BlueZone
Replies
0
Views
57
247xavi
247xavi
Daneyuleb
  • Locked
  • Question
Waitfortext1 -- How on earth does the RegularExpression option work?
Replies
2
Views
89
SkipVought
S
jeaneshe
  • Locked
  • Question
How do I select different Excel cells using a variable column loop?
Replies
10
Views
114
SkipVought
S
AlbertShenko
  • Locked
  • Question
Excel VBA Not Sending F keys to Attachmate 1
Replies
15
Views
160
SkipVought
S
Mike.and.H
  • Locked
  • Question
How to display date in EXTRA! X-treme window status bar?
Replies
0
Views
49
Mike.and.H
Mike.and.H

Part and Inventory Search

Sponsor

Back
Top