Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
First time with VFP to Excel
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00643532
Message ID:
00643681
Views:
19
This message has been marked as the solution to the initial question of the thread.
>* Problems start here:
>* VFP Doesn´t recognize xlCenter, xlBottom, xlCenter, etc., suposedly
>* Added with #Include.
> .HorizontalAlignment = xlCenter
> .VerticalAlignment = xlBottom
What happens if, instead of using constants, you indicate the value of the constants? Does the problem go away?


> " De " + ALLTRIM(STR(RECCOUNT()))
Tip: You can use: transform( reccount() ) and that will trim spaces as well.


>*Can´t use this, says "Expression is not valida outside With/endwith
>*I can´t use .cells even with some diferent ways of with-endwith
> .Cells(lnFila,1).VALUE = SALIDA.tdia
> .Cells(lnFila,2).VALUE = SALIDA.tinternet
I think the current WITH at this point is WITH loExcel. I don't think Cells belong to Excel object. You might need to wrap these calls with the appropriate WITH, for example WITH .Sheets(1)
Hector Correa
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform