For a website, are Excel scripts better than other programming language scripts?

[Advice Pro]

I'm new to Excel and I'd like to know since it's more organized are the
scripts better than other programming language scripts such as Ajax,
JavaScript, Java FX, etc.

 

[joel]

You could get thousands of answers to your question. What is Better? What
is more organized? I guess you don't like the other programming lanugages
that is why you are asking the question. What don't yo like about the other
languages then you can ask is excel better.

Excel scripts are Visual Prgramming Laguage (VBA) which is similar to
microsoft Visual Basic VB6 and VB.Net. The advantages of microsoft languages
is you can use the spreadsheett for I/O and storing data. You can also
access Access, Word, Power Point, Internet Explorer, Outlook from the
language. But there are things you can't do or easier to do from the other
languages you mentioned.

Each programming language has its advantages and disadvantages. None are
perfectrt for every application.

 

[Tim Williams]

VBA is not "for" website programming (since you mention it)

Maybe you could elaborate a bit ?

Tim

 

[Tim Williams]

I was going by the title of the post which was "For a website..."
It didn't mention downloading, so I took it literally.

Tim

 

[Larry]

If someone who has Excel on their computer goes the website and opens the
Excel file from the website, will the VBA code run?>

 

[JLGWhiz]

If the file is downloadable to the user computer, yes. Otherwise, no.
If the file on the web is designed to respond to a user interaction, it
could be described as the code running, but it would only be effective on
the web page and not on the user computer. I am sure this is a clear a mud.

 

[Tim Williams]

Yes, if you allow it to, but that would be very unwise except maybe in the
context of an intranet.

Tim

 

[Larry]

The excel file has VBA code and the customer can press buttons to activate
the VBA code. I would like for the excel file to run on the website only and
not be downloadable. How can this be done? Do we upload the excel file to
the website as a .XLS file?

 

[Tim Williams]

I don't think that's going to work.

Tim

The excel file has VBA code and the customer can press buttons to activate
the VBA code. I would like for the excel file to run on the website only
and
not be downloadable. How can this be done? Do we upload the excel file
to
the website as a .XLS file?

 

[Larry]

Thank you for your reply.
Can we upload the excel file as .XLS to the website. When the customer
enters the website, and presses the button to go to the excel file, can the
website download the excel file into the customer's computer's temp folder.
The excel file would auto_open in the customers computer.
So we would store the excel file on the website, but download and run the
excel file on the PC computer.
Would this work?

 

[Tim Williams]

Comments inline

Tim

Thank you for your reply.
Can we upload the excel file as .XLS to the website.

Yes.

When the customer

enters the website, and presses the button to go to the excel file, can
the
website download the excel file into the customer's computer's temp
folder.

Not exactly - the website does nothing other than serve up content: the
browser (user) decides what happens with the downloaded content. They could
choose to open it (in Excel or their browser, depending on config and
settings) or to save it somewhere on their computer.

The excel file would auto_open in the customers computer.
So we would store the excel file on the website, but download and run the
excel file on the PC computer.
Would this work?

Only if the end-user allows it (and unless it's a https connection I - and I
suspect many others - would not)

 

[Larry]

Thank you for your quick response.
You said they could choose to open it in excel.
So if we upload the excel file (.XLS) to the website, the customer could
choose to open it in excel. Is this correct?
Presently, we have a Power Point file on the website, the customer can open
and play the Power point file by pushing a button on the website.
Can the excel file be opened the same way? Push a button on the website and
the excel file opens?

 

[Tim Williams]

Why don't you just try it ?

Tim

Thank you for your quick response.
You said they could choose to open it in excel.
So if we upload the excel file (.XLS) to the website, the customer could
choose to open it in excel. Is this correct?
Presently, we have a Power Point file on the website, the customer can
open
and play the Power point file by pushing a button on the website.
Can the excel file be opened the same way? Push a button on the website
and
the excel file opens?