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!

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

EXCEL problem

Status
Not open for further replies.

EC1

Programmer
Jul 22, 2002
25
BE
hi,

i want to create one excel file (2000) within FOXPRO 7

oExcelObject = CREATEOBJECT('Excel.Application')
.
.
.
WITH oExcelSheet.Range("A1")
.value='THIS IS A TEST'
.interior.Color=RGB(192,192,192)
.Font.Name = "Courier New"
.Font.FontStyle = "Bold"
.Font.Size = 14
.Borders.LineStyle = 9
ENDWITH

Now i want to allign this.
This is the example in MSDN :
Worksheets("Sheet1").Range("A1:A5").HorizontalAlignment = xlLeft

Can anyone tell me what this xlLeft means or where i can found more information.

thanks

 
Slighthaze,

thanks for your reply.

Can you tell me where i can found this information. Next time i want to center the text, and i don't want to take another minute of your time with my little problems.

Thanks
 
ROB444,

File not found.

Can i ask you to mail it to me?
ec2810@hotmail.com

Many, many thanks

 
Hi !
This is a question for VBA Forum, but if you want to know ...
Excel -> Main Menu -> Tools -> Macro -> Editor VB (Alt+F11)
and you go to:
Microsoft Visual Basic -> Main Menu -> View -> Object Browser -> (F2) Monika from Warszawa (Poland)
(monikai@yahoo.com)
 
Thank you all. Problem solved.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top