64 Bit

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Owning a computer with 64bit processor
2. see above
3. ya

What is the expected output? What do you see instead?
Error when running on 64bit

What version of the product are you using? On what operating system?  With
what Salesforce.com edition?

Please provide any additional information below.

Original issue reported on code.google.com by cbl...@gmail.com on 30 Nov 2010 at 7:03

[GoogleCodeExporter]

I've got a 64 bit computer at work running Windows 7 and Excel 2007.  I haven't 
tried running the connector on Excel 2003 with a 64 bit computer, BUT... I've 
noticed that on Excel 2007, the EntityNames function doesn't return History of 
custom objects OR tables of detail objects with two or more master objects.  
This seems to be Excel 2007 specific.

Original comment by excel.su...@gmail.com on 18 Dec 2010 at 11:02

[GoogleCodeExporter]

does everything else work, but just this one function fail ?

Original comment by vneh...@gmail.com on 25 Jan 2011 at 3:02

[GoogleCodeExporter]

ok this code does not look excel 2010 64bit ready. 

am looking at fixing this and sending a patch set over when I get time.

Original comment by damien.j...@gmail.com on 1 Feb 2011 at 1:01

[GoogleCodeExporter]

The code does not work with W7 and Excel 2010 64bits.
"Compilation error" on opening the macro file.

Original comment by jcboulan...@gmail.com on 1 Feb 2011 at 3:29

[GoogleCodeExporter]

I can confirm that the 2010 version of Excel in 64-bit mode does not support 
sforce. Compilation error.

Any chance to fix this?

Original comment by okeiz...@gmail.com on 17 Feb 2011 at 1:33

[GoogleCodeExporter]

I concurr with okeiz, will this be fixed for Excel 2010 6t4 bit?

Original comment by jas513...@gmail.com on 21 Feb 2011 at 3:51

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Attached is the patch to make this office 2010 safe and 64bit ready, however 
the office tool kit is not 64bit ready or at least not working locally just yet.

Original comment by damien.j...@gmail.com on 21 Feb 2011 at 1:34

Attachments:

• [Office connector Patch.txt](https://storage.googleapis.com/google-code-attachments/excel-connector/issue-8/comment-8/Office connector Patch.txt)

[GoogleCodeExporter]

Excellent! Thanks! How can we patch the XLA? It's password protected...

Original comment by Dario.Lu...@gmail.com on 21 Feb 2011 at 11:29

[GoogleCodeExporter]

Thanks, but how do i get the patch installed?

Original comment by cbl...@gmail.com on 21 Feb 2011 at 11:37

[GoogleCodeExporter]

Hey, any update on how we can install this patch? Thanks soo much for putting 
it together, just need to get it running!

Original comment by cbl...@groupon.com on 4 Mar 2011 at 4:21

[GoogleCodeExporter]

Thanks for the patch, i'll rebuild the excel connector for PE as soon as i am 
able.  My calendar is booked until last week of March so i'll try for then.

Users with Enterprise should be fine to take the patch and apply it to their 
code base.

Original comment by vneh...@gmail.com on 11 Mar 2011 at 3:55

• Changed state: Accepted

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

How do we install this patch??

Original comment by duckybo...@gmail.com on 5 May 2011 at 6:27

[GoogleCodeExporter]

I think you need the Enterprise version and then you need to edit the source 
file provided.  I'm not sure how the 64bit stuff works since i don't have a 64 
bit windows box.  It looks like i may get one soon, then i would build a new 
version of the connector for 64bit win.   I hate having multiple version but 
i'm not sure it can be detected easily from visual basic such that it works on 
both 32 and 64.  

until then just apply the patch by editing the file.

Original comment by vneh...@gmail.com on 6 May 2011 at 3:09

[GoogleCodeExporter]

I've gotten pretty  close to getting this up and running in 64bit windows / 
64bit office. I'm mostly seeing compile errors at this point.

I think the main blocker here may be the toolkit...

Original comment by duckybo...@gmail.com on 12 May 2011 at 4:46

[GoogleCodeExporter]

Any updates?

Original comment by DavidMP...@gmail.com on 13 Jun 2011 at 5:50

[GoogleCodeExporter]

Looking for Office 10 use with Salesforce Professional -- with this patch.

Original comment by difaziol...@gmail.com on 19 Jun 2011 at 5:40

[GoogleCodeExporter]

I know the Winter '12 release of Salesforce will now support 64-bit Outlook. 
Anyone have an update with the 64-bit Excel connector?

Original comment by dp...@hubspot.com on 13 Sep 2011 at 6:51

[GoogleCodeExporter]

any update with getting office 2007/2010 working correctly with the toolkit? 
this is really setting me back

Original comment by drueff...@gmail.com on 17 Jan 2012 at 4:45

[GoogleCodeExporter]

sorry, no progress yet on this front.  I hope to have a 64 bit windows box that 
i can access to try it at some point soon.

Original comment by vneh...@gmail.com on 17 Jan 2012 at 5:30

[GoogleCodeExporter]

How do you get the patch to work or any ETA on getting this put into the actual 
product? I think this should be re-prioritized to High. Almost all new machines 
use a 64bit version of Excel.

Original comment by craig.hu...@gmail.com on 27 Feb 2012 at 5:42

[GoogleCodeExporter]

i will soon get a 64bit system, but still don't have 64 bit office at my 
company.  i ask around to see if i can find one.

Original comment by vneh...@gmail.com on 27 Feb 2012 at 6:06

• Added labels: Priority-High
• Removed labels: Priority-Medium

[GoogleCodeExporter]

Any update on this? I have added the patch to my 64 bit Win7 Office 2010 
environment, and the error has disappeared, but the toolbar function is still 
missing. So while it appears to be installed, the commands are not visible. Any 
ideas?

Original comment by gjre...@gmail.com on 3 Jul 2012 at 4:01

[GoogleCodeExporter]

Hi all , how can install this patch to my 64 bit Win7 Office 2010 environment 
thanks 

Original comment by rghanm...@gmail.com on 2 Nov 2012 at 12:31

[GoogleCodeExporter]

If you have 64 bit win7, ensure you are running g 32bit office/excel 2010 (the 
default from the installer anyway) then install office toolkit and excel 
connector as described in wiki/downloads. Should work fine now.
If you try to install in 64-bit excel it will give you an error and not work.

Original comment by ke...@kev-jones.com on 2 Nov 2012 at 1:56

[GoogleCodeExporter]

Just had Excel 2010, win7 updated to 64bit from 32 on as some of the sheets ran 
slowly / if at all and have been trying to get the connector back up since. Any 
news on a win7 64bit compatible version being available? Made me laugh as the 
s'sheets I was running were created with SFConnector in the first place! Should 
have checked. Doh!

Original comment by ilenno...@gmail.com on 19 Nov 2012 at 6:35

[GoogleCodeExporter]

I would love to see this product updated.  I just viewed a pitch for it by Nick 
Mannella at a Salesforce Dreamforce 2011 and this would be just what the doctor 
ordered.  I tried patching it but failed.  Can't get it to work and I hope that 
the developer will still consider an update to this as it came so highly 
recommended in an iTunes podcast/presentation.  Thanks for kindly considering 
this additional request to the ticket and thanks for the hard work.

Original comment by tho...@shoesthatfit.org on 29 Nov 2012 at 5:55

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

I do plan to implement an office 64 bit compatable version, however I cannot 
commit to a time frame as my current focus is with a startup that i've joined, 
Kenandy Inc.  This position takes all my time and spare time right now, but i 
hope to address this defect at some point soon.

it appears that a few users have it working, and so i think i can "package" 
that work but i won't know until i get my hands on a copy of office 64 and 
windows machine.

Original comment by vneh...@gmail.com on 30 Nov 2012 at 5:27

[GoogleCodeExporter]

btw Thank you ;-)

Original comment by Technola...@gmail.com on 5 Dec 2012 at 11:46

[GoogleCodeExporter]

Would be really great to see a 64-bit version of this. I attempted to fix by 
applying patch per Post 8, and addressed a few further compilation errors 
(changed a few Long variables to LongPtr) but even when it compiles without 
errors I still see nothing in the Add-Ins toolbar.

Original comment by pblack...@gmail.com on 12 Dec 2012 at 10:44

[GoogleCodeExporter]

Try this version

http://code.google.com/p/excel-connector/downloads/detail?name=sforce_connect_64
bit.xla&can=2&q=

let me know if it works, i have not tested it, but comes from a friend that 
claims it works.

Original comment by vneh...@gmail.com on 28 Jan 2013 at 5:03

• Changed state: Fixed

[GoogleCodeExporter]

I get an error message:

Compile error.
Attached a screenshot

Original comment by maddogpo...@gmail.com on 30 Jan 2013 at 8:09

Attachments:

• Capture.PNG

[GoogleCodeExporter]

Ditto Maddogpointdexter above - I get the exact same error, running Windows 7 
Enterprise 64 bit with Office 2010.

Original comment by gjre...@gmail.com on 4 Feb 2013 at 7:28

[GoogleCodeExporter]

ok, i guess i'll take this binary down, looks like it's not clear that there 
are two different 64bit issues.

1) windows 64bit OS
2) MS Office 64bit version

it's too easy to get these mixed up, and the binary i posted works for which i 
don't know ??

Original comment by vneh...@gmail.com on 5 Feb 2013 at 3:29

[GoogleCodeExporter]

Original comment by vneh...@gmail.com on 5 Feb 2013 at 3:29

• Changed state: Accepted

[GoogleCodeExporter]

I am facing the same issue, I hae 64 Bit sys., Excel 2010. 

Will be great if anyone can help, 
Thanks 
Alaa 

Original comment by a...@salesmena.com on 31 Mar 2013 at 7:19

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

I'll try to reproduce this, i think i have the correct system at work, thanks 
for your patience.

Original comment by vneh...@gmail.com on 1 Apr 2013 at 6:22

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

I am using Windows 7 64 bit and office 2010 (32 bit)

Original comment by julietma...@gmail.com on 10 Apr 2013 at 9:11

[GoogleCodeExporter]

I can install the 64 bit version of the connector on Windows 7 Office 2010 - 
however i get an error when i try to login to our SF professional account.  See 
the images attached.

Original comment by RichardJ...@gmail.com on 10 Apr 2013 at 9:17

Attachments:

• Capture2.PNG
• Capture1.PNG
• Capture3.PNG
• Capture4.PNG

[GoogleCodeExporter]

Cannot install the pluging - compilation error
It would be AMAZING to have a new version of this one

Original comment by oron...@gmail.com on 29 May 2013 at 6:24

[GoogleCodeExporter]

everywhere in the project that says "Declare Function"  needs to be changed to 
"Declare PtrSafe Function"

this worked on a 64bit OS with a 64bit Office up to 2010.

it does not seem to create the add-in menu structures in 2013, i suspect at 
this point it would need to be reworked in Visual Studio to be compatible with 
the new Ribbon UI.

however since the office tool kit is stuck at version 16 of the salesforce API, 
and MS is moving forward with the Metro/tiles and more importantly web services 
directly in the office applications (not to mention the 3rd party support 
nightmare that will come with Office365)....

argh!   i feel all of your pains.  this was a crazy useful tool, and is sorely 
missed.

Original comment by tuomala....@gmail.com on 26 Sep 2013 at 11:25

[GoogleCodeExporter]

oh, just found this

http://support.microsoft.com/kb/2761240

i'll try it out as soon as i can

Original comment by tuomala....@gmail.com on 26 Sep 2013 at 11:43

[GoogleCodeExporter]

Win 7 64 bit / Excel 2013 64 bit.

I added in "PtrSafe" as mentioned 2 posts above, and now there is no error, 
however am unable to see it in any "Add In" ribbon?  I can clearly see it 
checked as an Add-in, but it does not appear anywhere.  Any luck from anyone 
else?

Original comment by jasoncj...@gmail.com on 18 Oct 2013 at 6:04

[GoogleCodeExporter]

I am having the exact same issue mentioned above with 64bit Excel/Windows. The 
errors have gone away when I added "PtrSafe" however the "Add In" ribbon is 
long gone. Help!

Original comment by travis.k...@contextmediainc.com on 7 Nov 2013 at 7:07

[GoogleCodeExporter]

adding "PtrSafe" to the declare function worked. I added the add-in but it's 
not showing on the ribbon

Original comment by bfor...@gmail.com on 20 Nov 2013 at 7:05

[GoogleCodeExporter]

Just tried using sforce_connector_ee_1603 on a Win8 64bit, encountered error as 
shown in the screenshot.

Original comment by jaydeeps...@gmail.com on 3 Mar 2015 at 1:26

Attachments:

• sfexcel.JPG