Re: Error Aligning in Excel doc

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Re: Error Aligning in Excel doc

Logged in as: Guest

arrSession:exec spGetSession 2,2,1978

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

Printable Version

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

Page: [1]

Message

<< Older Topic Newer Topic >>

Re: Error Aligning in Excel doc - 2/3/2005 10:47:05 PM

seanog

Posts: 2
Score: 0
Joined: 2/3/2005
From:
Status: offline

I am trying to do a horizontal alignment on the J column in Excel,
but am getting hte following runtime error:Unable to Set the HorizontalAlignment property in the Range class

Set objxl2 = CreateObject("Excel.Application")
set fb=objxl2.Workbooks.Open("C:\Fran\SHEMLOG.csv")
set Shipsheet = fb.activesheet

Shipsheet.Range("J:J").HorizontalAlignment = xlHAlignCenter

Any Suggestions?