VBA / NET

Nasser
StarLounger
Posts: 56
Joined: 11 May 2010, 10:26

VBA / NET

Post by Nasser »

Hi,

I heard that an excel /VBA can be opened from the NET. I have developed a program in excel VBA and i am thinking if it is possible to get access the program from the internet. I think i first need to ceate a web page, is that right?

Could you please give me some guidance how the students can get into my program from the internet instead of opening the excel and get through the applications.

Cheers,
Nasser.

User avatar
HansV
Administrator
Posts: 78863
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: VBA / NET

Post by HansV »

Yes, you'd need to create a web page for that, and to have space on a web server to store it.

You can save the workbook to the web server, and make it available as a link on a web page. The users can then - depending on their settings - open the workbook in their browser or in a separate instance of Excel, or download it to their hard disk. They would need to have Excel installed on their PC.

For Excel 2000, 2002 and 2003 there was an Excel Web Component that mimicked much of the functionality of stand-alone Excel, but there is no version for Excel 2007 or 2010.
Best wishes,
Hans

User avatar
Jan Karel Pieterse
Microsoft MVP
Posts: 656
Joined: 24 Jan 2010, 17:51
Status: Microsoft MVP
Location: Weert, The Netherlands

Re: VBA / NET

Post by Jan Karel Pieterse »

Note that if the file is opened INSIDE internet explorer, some functionality of your VBA code may not work as expected.
Regards,

Jan Karel Pieterse
Excel MVP jkp-ads.com

User avatar
HansV
Administrator
Posts: 78863
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: VBA / NET

Post by HansV »

Good point, thanks for mentioning it!
Best wishes,
Hans

Nasser
StarLounger
Posts: 56
Joined: 11 May 2010, 10:26

Re: VBA / NET

Post by Nasser »

Hi,

I will come sure to ask more questions when i create the web page.

Many thanks
Nasser.