Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing a Calculated field from Excel
Message
From
10/03/2004 17:54:30
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00884994
Message ID:
00885031
Views:
10
>Hi.
>I have set up a routine to import a file from Excel, but notice that if one of the columns is a calculated field (e.g. = Round(A1 / 100,2) , funny characters get into the imported field.
>
>Anybody know of a way round this ?
>
>Regards,
>
>Gerard

Perhaps you might use the Copy & Paste Special commands in Excel first, to paste the values only, into another range.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform