Remotely running VBA (*.xlsm)

[Oseitutuakrasi]

Hi All,

Is there any technology that I can use to allow clients to run .xlsm workbooks from my website remotely from their computers?
Clients can download the files onto their computers and run from there. What about running them directly from my website
as shown below?

 

[6StringJazzer]

VBA has to run on a machine. If the user doesn't download the file, that means it has to run on your web server. That means that Excel has to be running on your web server. Even if you could do that, I'm not sure how you can invoke VBA over an HTTP connection. What would the VBA do, from the user's point of view? How is your web site hosted?

 

[Oseitutuakrasi]

Thank you so much Jeff. So, effectively you are saying it is not possible? That's why I asked if there is any technology around that I did not know of.
Thanks a lot, I will not waste my time on this then.

Regards

 

[6StringJazzer]

I'm not saying it's impossible, but I've never seen it done. The possibility depends on several factors, primarily in how your web site is hosted and how much control you have over the server.

 

[Oseitutuakrasi]

Ok I see Jeff. I will do further investigation on this.

Regards
Samuel