Send fields from local webpage to Excel spreadsheet

[NascarBaritone]

I have been messing around with a simple form that my co-workers and I were going to use over our local computer, no server, just local network. Is it possible for me to build a "Submit" button on the webpage (which is stored as an .html file on a common directory) and have all information in the various fields (textboxes, checkboxes, etc.) sent to an excel spreadsheet?

And, before you tell me to use Access, I thought about it, but I already had the page built and was hoping this method might work.

Suggestions?

 

[HiTechCoach]

What web server are you using?

Are you wanting to create an excel file from the web page's data?

 

[NascarBaritone]

I'm actually not using a web server. I thought that might be the snafu because I don't exactly understand how the server plays into it. I was just hoping to do something similar to using a server, but without the server. Fill out a webpage, click Submit, info goes to a (possibly merged) Excel spreadsheet.

I think I might be way out in left field.

 

[HiTechCoach]

I'm actually not using a web server. I thought that might be the snafu because I don't exactly understand how the server plays into it. I was just hoping to do something similar to using a server, but without the server. Fill out a webpage, click Submit, info goes to a (possibly merged) Excel spreadsheet.

I think I might be way out in left field.

Normally when you click "submit" you will run asome scripting language (PHP, ASP, Perl, etc) which requires a web server to process the script.

Since you do not want to use Access:
If one of your machine has XP pro as the OS, then you can install the IIS web server for the installation CDs. You can then learn to write ASP code (VBScript) and create a script to that uses Excel automation to take the data form the Web form and insert it into a spreadsheet.

FYI:
I have done web based applications in ASP to move Access apps onto the web. I also fo ASP based web sites fro portals/CMSs. It typically takes 20 to 30 times longer to build a web app than to create the same thing in Access app.

 

[Dickpanther]

Hi Everyone, I'm new here but hoping someone has an answer for my situation.

I took over as officer for a club & the previous officer e-mailed me his spreadsheet containing club member names in alphabetical order. I copied & pasted his list of names, 7 pages, into my "OpenOffice" spreadsheet. I then clicked on "Tools" & put "X"s in each box if those members had paid for the 2013 year which was fine. I then converted this OpenOffice to a PDF file & saved it as that.

The problem is that I find there are some old, old members who are no longer active in this club & I would like to "Delete" them but seems that I cannot.

Additionally, I have new members written w/ pen on seperate sheets of paper that I would like to add to this spreadsheet, in alphabetical order but don't know how to do that either so I'm left w/ an outdated spreadsheet plus sheets of paper w/ new club member names.

Thank you in advance.

DickP