Publish Excel/VB to Web

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

AMorrison0903

Thread Starter
Joined
Apr 11, 2008
Messages
79
Hello Guys...

I have a program I made within Excel using some basic VB programming. I would like to use it as a webpage and some interactivity, but it doesnt seem to work...

Any ideas?

Thank you!
 
Joined
Jul 25, 2004
Messages
5,458
Hi there,

Can you explain what it is exactly you are trying to do, and exactly what it is that you have done? What is the entire scope of your project?
 

AMorrison0903

Thread Starter
Joined
Apr 11, 2008
Messages
79
I have an excel program that I have programmed some VB into as well, so it has macros and formulas and vb functions.

When using the program within microsoft excel, it works great.

What I would like to do is be able to use this on the internet and run the excel program from the internet. I dont want people to be able to download it or view the code... just be able to use it from a web page.
 
Joined
Jul 25, 2004
Messages
5,458
Ah, well that is pretty much out of the question. From the web, things are run on HTTP protocol, and VB/VBA is not recognized. To be able to run that you would need an application which recognizes and runs the code, which means you'd still need the application.

Some options would be to keep the file on a website and allow people to open, perhaps not save (which means nothing if somebody wants to store it locally on their own machine), or perhaps using collaborative software, i.e. jedox or Groove.
 
Joined
Oct 20, 2004
Messages
7,837
I would suggest that you look into Java or Javascript (depending on what you are doing with your VBA) for running it on the web. Both can be hidden (well, pretty much, but not if someone is skilled and determined enough) from view.
 
Joined
Jul 25, 2004
Messages
5,458
Are you familiar with having Javascript run VBA procedures? Or are you meaning to re-write all of your procedures in JS?
 
Joined
Oct 20, 2004
Messages
7,837
Me? heck no - I am afraid I am suggesting a re-write. From what I know of both (and the little VB and VBA I know), I would think that you might be able to imitate some, probably most, of such functions.
Given that AMorrison0903 says "some basic VB programming" (hopefully not a lot) and "I dont want people to be able to download it or view the code" - well, that basically rules out using Excel, really.
VB/VBA also has problems with non-Windows OSes (???), so it is far from what you want on the web.
 

AMorrison0903

Thread Starter
Joined
Apr 11, 2008
Messages
79
Alright thanks guys... I may just make the file a read only and protect it and then distribute it from the website to be able to download.

Thanks for the help.
 
Joined
Oct 20, 2004
Messages
7,837
As long as the people who will receive it have Excel - Open Office (and I think other) spreadsheet programs don't generally recognize VBA, and I don't think VB is either (it is a MS product....) - so if you have functions built in that you want everyone to use, you may have to reconsider how you have it done.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Top