VBScript in Excel

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

VBScript in Excel

Logged in as: Guest

arrSession:exec spGetSession 2,2,507

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> VBScript in Excel
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

VBScript in Excel - 12/1/2001 2:27:38 PM

CR0WL3Y

Posts: 1
Score: 0
Joined: 12/1/2001
From: Brazil
Status: offline

Sorry for my English, I'm Brazilian and don't speak your language very well (as you can see

)
Look at this:

Set plnXL = WScript.CreateObject("Excel.Application")
plnXL.Workbooks.Add
plnXL.Application.Visible = True
plnXL.ActiveSheet.Cells(1,1).Value="Value1"
plnXL.ActiveSheet.Cells(2,1).Value="Value2"
plnXL.ActiveSheet.Cells(1,2).Value="Value3"
plnXL.ActiveSheet.Cells(2,2).Value="Value4"

Allright, but how I make a Border on that range of cells?

plnXL.Range("A1:B2").Select
plnXL.Selection.Borders.LineStyle = 1 'xlContinuous

Something like that, but without the Vertical lines, just the borders around all Range.

Thanks

LC