What's the Add-in API for workspace to refresh the sheet?
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.
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
It could be the Workspace Add-ins on Excel.
You can refresh workspace from the Add-ins menu.
For the VBA code, please refer to the answers on this discussion.
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
Do you want to invoke it from another excel file?
I don't think it works that way.
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
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.
