• shreya Sharma 42
  • 0 Points
  • Member since 2023

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
  • 7
I am trying to find out how to use the contents (value) of a cell as an Excel  power query parameter. I have set up a power query to get data from a Salesforce object (table) and that works. I am also able to filter the records returned using a filter value (a constant that identifies one record) and that works. How can I select a single record from the object (table) by referencing the cell contents (a value that is the key value of the one record I wish to return). I have tried defining a named range (name manager) to identify the cell value and an excel table to identify the cell value, but I can't find the exact syntax to get either working in the filter.  I will greatly appreciate whatever responses that I get from the user communirty. thank you.
We are getting records from salesforce to VBA for one object but not receving their related object data.

can someone help on this?
I found a user-friendly and easy Migration process third-party tool that quickly migrates 'protected-password' OST files into Office 365 including Emails properties or mailbox attachments such as-: Task, Emails properties ( To, Date, From, Subject and etc.), Mailbox attachments, Inbox, Outbox, Draft, Contacts, Calendar items and etc. This tool will help you in Export data from inaccessible OST files to Office 365 with it also save then items into multiple files formats such as- PST, Gmail, Zimbra, MSG, EML, EMLX, vCard, ICS, PDF, OLM, NSF, Office 365, Live Exchange and etc.
  • Split large size of OST files to the smaller part
  • Batch Option to selects multiple OST files items.
  • Messages filtering option to Convert OST to MBOX by according to Date and etc.
  • Convert OST Contacts to the vCard file format.
  • Restore Password-protected OST files into Outlook.
More Info-:  OST to Office 365 Migration

User-added image
I've connected various queries to Excel using Microsoft Excel Power Query. Unfortunately, I have to log in each time again at Salesforce via a dialog window. Is there a VBA script with which I can automate this login?
I'm having around 20k+ emaila in my OWA mailbox. Since our organization is moving to Google Apps now, we need to export the whole data. Could anyone suggest how do I do it?
I am trying to connect Microsoft Access (from Office 365) to salesforce.  I have followed the instructions in the following link:

When I attempt to link a new table to Salesforce, I use my credentials in the Connect to Salesforce login.  Then I get a linked tables dialog, in which all the Salesforce objects are listed.  I choose one, then get the following error:

The Microsoft Access database engine could not find the object MyOrg..Pricebook2.  Make sure the object exists and that you spell its name and the path name correctly.  If MyOrg..Pricebook2 is not a local object, check your network connection or contact the server administrator

I have enabled the Use Any API Client permission for myself.  However, in the Connected App persmissions, I haven't been able to find anything I can identify as what Microsoft Access is using.  This might be a clue.

Thanks for anyone's help!
Hopefully someone can help me as I've been stuck on this for hours. I need to write macros for a number of functions in Excel VBA to access and manipulate SF data. I've had success using the sforce Connector addin via GUI but I now need to move to VBA. HOWEVER, everywhere I look online I see the step "add a reference to SFDCExcelAddin" and I can't figure out how to do this. I don't have SFDCExcelAddin in the Object Explorer. I do have "s_force" in the object explorer but it does not contain the same methods. Where is this located?? Thanks to anyone who is able to help!