refreshing a table in m files admin via VBA

hi all hope everyone is having a great day I'm looking for an excel vba that would open my m files admin and refresh my customer table automatically instead of me having to right click on my customer table from the meta data and click refresh.

Thanks any answers are very appreciated 

Parents Reply Children
  • The method I gave you is the correct one, but you will need to connect to the vault to be able to run it.  You need to have a few steps in your VBA:

    1. Connect and authenticate to the vault.  Maybe use a client connection: Connecting and Authenticating (m-files.com)
    2. Execute the RefreshExternalObjectType API method I mentioned above ("Vault.ObjectTypes.RefreshExternalObjectType(123, MFExternalDBRefreshType.MFExternalDBRefreshTypeFull)")

    Can you try that and see how far you get?  I appreciate the sample code I linked at #1 is in C#, but hopefully you can follow the general process.