Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel selection data format
Message
From
11/10/2007 15:08:52
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01260318
Message ID:
01260395
Views:
9
>>how should I set the cell format for numbers, text, dates, etc..
>>
>>oXL = Createobject("excel.application")
>>With oXL
>>    lcold_a						 = "#@"
>>    .Workbooks.Add()
>>    Scan
>>        .Range("B"+Alltrim(Str(lnLinha))).Select
>>        oXL.Selection.Characters.Text = mytable.myfield
>>    endscan
>>endwith
>>
>>
>>TIA
>>
>>Claudio
>
>Check:
>
>Message #1253503
>Message #1091417

cool Borislav!! thanks a lot!!
"Now to him who is able to do immeasurably more than all we ask or imagine, according to his power that is at work within us, Ephesians 3:20
Previous
Reply
Map
View

Click here to load this message in the networking platform