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
David_Adam_CoheDavid_Adam_Cohe 

Error 424 object required

I'm getting an error when trying to update a number field.

 

Similar fields update fine, the settings are the same, the format in excel is the same.

 

This is driving me up a wall.....

 

any help would greatly be appreciated

 

 

 

David_Adam_CoheDavid_Adam_Cohe

additionally, it is only on an update action, not on an insert new account

 

moreover, as soon as you insert it, it doesnt work when you update

 

AND

 

the error describe above happens in the same sheet!
I_AM_JJI_AM_JJ
Also getting the Error 424 when trying to update a Number field - the field is 12 hours new - could that be the issue?
JAW99JAW99
Any solutions found?
WilmerWilmer

Hi, I have the same issue. Does anybody have a solution to this?
bvdbbvdb

Try switching your API version from 6.0 to 7.0 when you initially login through Excel Connector.

 

When it prompts you to login, click the Advanced button and change the 6.0 to 7.0. This solves a bunch of problems and it just so happened to work for this one.
GuyClairboisGuyClairbois

The following VBA hack worked for me:

(found here: http://code.google.com/p/excel-connector/issues/detail?id=6)

 

The original code was: 
If Right(vntValue.NumberFormat, 1) = "%" Then AdjustFieldtype = AdjustFieldtype * 100

The new code is:
If Right(vntValue, 1) = "%" Then AdjustFieldtype = AdjustFieldtype / 100