We have been using the EE version of the excel connector agains a PE version of Salesforce. It has been working ok. Is there something we should be aware of?
The reason we have done this is because the PE version of the connector does not allow us to look at the VBA code. It is password protected.
I would like to create a button in excel that will basically run Query Table Data from the sforce connector toolbar. I tried to record a macro, but the record does not pick up anything from the sforce menu. I also looked at the VB editor, but everything in there related to the connector is password protected.
I am having a problem inserting a new opportuntiy. Here is the error message I get
Salesforce: Create()
invalid Range, missing datatype, or other error
type is : Opportunity
Value out of range
I have narrowed down the problem to two custom fields I am trying to load. Both are percent fields. When I just type a value into the cells for those fields the insert works just fine. When I put a cell reference in there for the value, I get the error mentioned above.
I have salesforce enterprise and am using Excel Sforce connector. I have tried loggin in to the visual basic code as instructed in the instructions by pressing alt F11. This works but when I try to view the sforce_connector code it prompts for a sforce_connector password. I have tried using my salesforce password but that doesnt work. What is the password I should be using?
I have tried to create a simple macro by using "Record New Macro" to Launch the Connector. It doesn't work. Does anyone know a simple way to create a macro that will launch the connector and even run a query? I am not a VB Programmer, so I would prefer to keep it simple. Thanks!
