There are
a several versions available, the latest with the newest features and a few
prior versions in the event that you discover a compatibility or
feature issue which would require you to backup and reload the previous
version in order to get your work done.
In general all changes attempt to maintain compatibility, however I
don't do a lot of testing using files generated by older versions, and
I don't run regression tests on Excel XP (Excel 10) any longer, just
Excel 2003
(Excel 11)
As always please feel free to let me know if I've broken anything, I
mostly read the
sforce "VB and Office Development" board, and try to get to the
CRMSuccess boards but not as often.
Ron Hess
Download
Version 6.16
Jan 2006, Winter06 release.
Tested with Office Toolkit 3.0 , which is installed by the
current version of
Outlook Edition, yes that is correct, from the salesforce personal setup
please install the Outlook Editon, this will install the required 3.0 COM objects used by the Sforce Connector ( guess it should be AppExchange Connector now...)
The above version replaces the 6.05 version which had a problem (read: bug) with currenccy in rare cases, in any case, thanks go out to the guys at F5 for pointing out this problem in 6.05 and verifying that it's
fixed in version 6.13.
Also thanks to the Salesforce.com SE team who pointed out my problem with pennies in euro currencies, and for providing a good test case which i was able use to correct the issue.
This version also contains a feature on the options tab to enable an update on a worksheet even if it has autofilter turned on, Thanks Erik!. This feature is not on by default, by default you would end up updating all the rows in a region, even those that were hidden by autofilter.
Other cool feature in this release, HTML Hyperlinks stored as formulas
in salesforce.com now
come out into the worksheet as clickable links, cool huh?!
Oct 2005, BETA: simple port to Toolkit Version 3.0, requires new Office Edition / Toolkit install, here ->
MSI install
( also see Office Toolkit for doc )
add new wizard step to select columns to add to query, query now clears out old comments
in the target region.
Download
Version 5.61
July 2005, add new option page to allow queries to return related names
instead of ID's for
Contacts and / or Accounts.
note this may impact performance so please enable these options with
care and
understanding. This option may cause an additional query for each row
of the table you are pulling.
Also, this release includes a workaround for sfaccount() function which generates
faults when calling Search() in latest office toolkit
A few cosmetic improvements to add API names in the comments returned
by the "Describe" menu.
Add Exception code in error messages, just for fun.
Download
Version 5.51
April 2005, Allow "empty" dates in the query, so you can now say "Date
Field", "equals", empty, which is very handy to find records which are
missing a date. Also a minor fix for inserting AccountShare rows, be
sure to use "Edit" instead of "All" when inserting share records using
the connector.
Download
Version 5.48
April 2005, Correctly support user names in query value fields, percent
fields found in excel now load properly, add enhanced wizard
dialog. Working on non-blocking updates, a mass update can
now
proceed past single cell errors which are then flagged for later
review. fix QueryAll in slient mode.
Download
Version 5.40
March 2005, Finaly got batch loading working, inserting will continue
past errors, then go back and mark the failed rows
minor fix for group names which are blank, and corectly return
reference to org as the org name
Download Version 5.35
March 2005, return string names instead of ID's for Profile, Role and
Group, GroupMember;
fix a poor error message when an incorrect passwd is entered,
fix "starts with" operator when passing a comma seperated list of
values
Download Version 5.33
Feb 2005, minor bug fix to allow user names on insert and "starts with"
in query
Jan 2005, Map User names in query,update,insert, limited join
functionality
Dec 2004, Added Option dialog to allow use of API Names instead of
Application Labels
Dec 2004, Options to run Assignment rules on case and lead insert,
online help file
Nov 2004, Added Join functions, left join and field,IN,Range join,
field ON range
Nov 2004, Added TODAY +/- N syntax for date fields in query, see screen
shot
Download
Prior Version
Hey, it worked for a long time..