function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
efantiniefantini 

Problem with data type conversion with sforce office control

Hi all,

from an exel worksheet i'd like to update an opportunity including the amount field. The amount field is defined as currency, therefore i expected to use CCur or CDbl, CDec, Round to convert my cellvalue into the valid field type.

Unfortunately i got working only the CLng function, but of course in this case i loose the decimals.

sopportunity(0).Item("Amount") =CCur(ThisWorkbook.Sheets("FORM").Range("J54").Value)

Any suggestion?

Thanks

Regards