First of all thanks for creating this, the excel-connector is brilliant.
I have a list of account IDs which need various fields updating.
To do this I run the table query wizard, select the object and then the fields
and on step 3 close the wizard so I'm left with the relevant columns and a
blank table.
I paste the IDs into the left most column then highlight the cells and select
query selected rows and this populates all the columns and I can update as
required.
All so far so good, the issue I have is with records which have been
subsequently deleted, when I run the query and it hits an ID which no longer
exists I receive the following error:
Salesforce: Update()
invalid Range, missing data type, or other error, type is: Account Object
variable or With block variable not set
Understandable since the account record in question has been deleted but how
can I get the query to carry on querying the other rows?
Currently I receive the error and the cell is highlighted in yellow, I skip the
dodgy one and select the next bunch or rows and run the query again, it
populates the data until it hits a deleted one and I again have to stop, select
the next batch and run again which is very time consuming.
Many thanks in advance.
Dean
Original issue reported on code.google.com by ddv...@gmail.com on 28 Jun 2011 at 11:31
Original issue reported on code.google.com by
ddv...@gmail.comon 28 Jun 2011 at 11:31