What's the Add-in API for workspace to refresh the sheet?

Options
ABCDEFGHIJ
ABCDEFGHIJ Newcomer
edited July 18 in Workspace SDK

What's the Add-in API for workspace to refresh the sheet?

Tagged:

Answers

  • raksina.samasiri
    raksina.samasiri admin

    Hi @ABCDEFGHIJ ,

    Your question is about Workspace Excel functionality, rather than about the API usage.

    The best approach is to reach out to Workspace support directly, by submitting Workspace Excel question via My Account rather than posting on dev forums. And the helpdesk is going to support you on this.

  • ABCDEFGHIJ
    ABCDEFGHIJ Newcomer

    hi @raksina.samasiri , the workspace support said they do not cover this part. They suggest me to raise a query here. I need the Excel VBA call function name of the Add-in "refresh the worksheet". there should be a module name available but cannot see in the object browser

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    It could be the Workspace Add-ins on Excel.

    image.png

    You can refresh workspace from the Add-ins menu.

    image.png

    For the VBA code, please refer to the answers on this discussion.

  • ABCDEFGHIJ
    ABCDEFGHIJ Newcomer

    hi @Jirapongse Thanks for the answer. how can i use in my module? seems the code does not work Sub test()Application.Run "'test.xlsm'!REF Price.WSRefreshSheet"End Sub

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    Do you want to invoke it from another excel file?

    I don't think it works that way.

  • ABCDEFGHIJ
    ABCDEFGHIJ Newcomer

    it's the same file, i copied the code to my vba sheet and would like to call it from the vba module, i tested it in the single module with public sub it works but if i embedded in my other vba module code it will show error

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    You can specify the sheet name in the code. It looks like this:

        DoEvents

    
    Application.Run "WorkspaceRefreshWorksheet", True, 120000, "Sheet1"

    
    DoEvents

    Please share the simple Excel sheet so I can check it.

Categories