New posts are disabled while we improve the user experience.

You can browse the site, or for urgent issues, raise a query at MyAccount.

question

Upvotes
Accepted
Alex.Conti avatar image
7 ●2 ●2 ●4

Issue with "WorkspaceRefreshWorksheet" on Workspace VBA

I'm having difficulty with including the workbook name on "WorkspaceRefreshWorksheet". I'm using:

Sub WSRefreshSheet()
    DoEvents
    Application.Run "WorkspaceRefreshWorksheet", True, 120000, "[Book1]Sheet1"
    DoEvents
End Sub

But it doesn't run unless I remove the Workbook name ([Book1]). Works perfectly fine if only "Sheet1" is on.


"[Book1]Sheet1" runs well on Eikon via the "EikonRefreshWorksheet" function but seems to be bugged on Workspace. Is there something wrong with the VBA code or is "WorkspaceRefreshWorksheet" bugged?


Thanks in advance!


eikonworkspace#technology#productvba
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
87.8k ●294 ●53 ●79

@Alex.Conti

Thank you for reaching out to us.

I tested with "Sheet1".

However, this macro is in Workspace Excel. Please contact the Workspace Excel support team via MyAccount to verify this behavior.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.