Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Field and Need For a Carriage Return
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00875990
Message ID:
00875991
Views:
21
This message has been marked as the solution to the initial question of the thread.
>I am creating an Excel Spreadsheet using VFP Automation.
>I would like to place a text string in a Cell, but I want to control where the string breaks. So if I send "Hello There Bret" I want the Cell to show:
>
>Hello
>There
>Bret
>
>But I cannot figure out how to send a set of characters to Excel that would be interpreted as a carriage return. If I send CHR(13) then it just put a non-printable character in the string when I bring up the Excel Spreadsheet.
>
>Any help would be appreciated.


Use CHR(10) instead of CHR(13)
Charles

"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform