Accessing a Calc sheet on a Server with Macro

[Amylase]

Hello,

I have been reading stuff here for a long time and found everything I have been looking for until now. Here is my question, unfortunately I think based on what I have read so far it is not possible but here it goes:

I have a macro in basic for a calc sheet that I want to use the data for a website. The dates update realtime which is great but the macro wont update or even run for that matter. I don't want the sheet downloaded from the website. I would just like the macro to run before website viewers see the data. Does anybody know how to do this?

Thank you soooo much!!

[RoryOF]

How does the macro know that web-viewers are coming online? Why not trigger the macro from a timer or after the realtime update of the data?

[Amylase]

As the webpage refreshes each time it is opened, I hoped that would be enough.

I could give a timer a try...

Thank you

[Amylase]

The timer worked great until I uploaded it on the server. It still won't recalculate/refresh. Any other ideas? Thank you