web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Use VBA to press 'Refr...
Microsoft Dynamics CRM (Archived)

Use VBA to press 'Refresh from CRM' button in Excel 2010?

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

Has anybody managed to use VBA to programatically press the 'Refresh from CRM' button in the ribbon in Excel 2010? If so, how do you do it? Recording a macro and then pushing the button manually gives no clues in the recorded macro output.

Thanks,

JT

*This post is locked for comments

I have the same question (0)
  • yleclerc Profile Picture
    yleclerc 1,549 on at

    I know it has been a while since you posted, but I think you could use the "Refresh" feature instead (Not "Refresh All").

  • Jaz0894 Profile Picture
    Jaz0894 5 on at

    Hey Yvan, refresh or refresh all does not work if you don´t press "Refresh from Dynamics" first.

    I´ve tried looking for a way of calling the action of this add-in from VBA from a time now and I have not been able to do so. I wonder if someone else could help or if we can get an answer from Microsoft on this.

  • yleclerc Profile Picture
    yleclerc 1,549 on at

    I am not a developer so VBA remains a secret for me.

    The thing I read somewhere else is that when you click on "Refresh from CRM", Excel actually tries to authenticate the user to the SQL Database, and that somewhat explains why you can't run it in a macro and/or VBA.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans