MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Interactive Excel on Web

  Asked By: Dora    Date: Aug 17    Category: MS Office    Views: 1587

I am starting to get into VBA programming, especially in Excel.
My first question is, can anyone offer tips, how-to-get-started, etc.
for doing the following: I have an Excel document that has a list of
tasks I do for my company's website. I want the other employees in
my office to be able to update this Excel document OVER OUR WEBSITE.
Users should be able to view the Excel file, make changes, add items,
and save the Excel on the Web. All users edit the same Excel file.
Any help on getting started on this would be really appreciated. It
is a requirement that this Excel file is updated by the users on the
WEB (directly or some other clever method).



3 Answers Found

Answer #1    Answered By: Archer Smith     Answered On: Aug 17

Lets see if I can answer you.

For everyone to be able to modify the document  they would have to
have access to where the document is stored.

Will the document be used across the Intranet or the Internet?

Answer #2    Answered By: Ida Andrews     Answered On: Aug 17

The document  will be used across the internet. Anyone should be able to open
the Excel file  from anywhere in the world, assuming they have Excel installed.
What I am trying to essentially do (using this project) is come up with a way
such that users  can update  information on our website  for their own 'accounts'.
We help  run many projects and users need to be able post updates on their
projects in a clear and organzied fashion.

Answer #3    Answered By: Lionel Thomas     Answered On: Aug 17

Its sounds like a situation where you have a form, the
action of this form is to send the information to a
website that captures the information to store in a
database or file  to print.

The next step therefore is to see whether Excel can
act as a form, accept the data from any user on the
internet and send back to you.

Didn't find what you were looking for? Find more on Interactive Excel on Web Or get search suggestion and latest updates.