Local web form to excel spreadsheet

hi Chris,

Have you made the web form? How are you updating the spreadsheet from it?

Hi Kyle123,

Thanks again for such a swift response.

I haven't made the web form yet.

The current set-up is that I update the target spreadsheet manually, with each line of information sent to me by email from nearly 20 different sources. My vision is that everyone in my team has access to a form via Internet Explorer/Firefox where they can fill out the information that they would normally email to me for it to automatically populate in excel.

I have uploaded an example of the 'ITEM TRACKER.xls' (target spreadsheet), and the 'ITEMTRACKER-Web form.jpg' (web form preview screenshot) this is not the final version but it should give a much clearer idea of my goal.

Ah ok, is this an infopath/sharepoint combo?

If so, not really my forte, I've never used infopath and my sharepoint is somewhat limited at best.

Sorry

I don't believe so. If you have any ideas how you would set up a solution to this problem I think it would be a great starting block, then I can work from there to see if it works in my environment.

Let's say, how would I do this just on my personal computer?

If you were set on having this as a webform, then it can be done quite simply....... but

1. All users must be running Internet Explorer
2. All users must have access to the spreadsheet
3. It's generally not a recommended approach.....

If you can't meet criteria 1 & 2, you either need to utilise sharepoint or you need a server side solution and that feels overkill for what you are doing.

I've attached 2 docs, the first is an html document, the second is the Excel Database, you'll need to save this somewhere and then edit the path in the html document to reflect where it is saved. (you can use notepad for this)

This should get you up and running, I've written the script in VBscript so it is very similar to Excel VBA.

Hi Kyle,

Thank you, that's brilliant. Only issue is that each entry populates on line 2 of the spreadsheet, and overwrites what has already been input.

Is there a simple change I can make to the VBscript to locate the next available clear line?

Try that:

Please Login or Register  to view this content.

Hi Kyle,

I'm afraid that I can't get that bit to work. If I try it with a blank 'SampleDB' it doesn't insert anything, and if I try it with a 'SampleDB' with something already in it nothing changes either.

hmmm works for me. Try it with the sample I uploaded, it needs to have 4 column headers.

Just a quick one, you've refreshed the browser after saving your changes right?

Hi Kyle - Apologies scratch that didn't update the path when I copied in the new code (rookie mistake).

It seems to be working absolutely fine now. Thank you very much!

I will be working on testing this with increasing numbers of people to see if we get any conflicts but for now I see this as completely solved. I owe you two now Kyle! Thanks again.

no probs.

Just remember as I mentioned above - this only works on internet explorer.

please help with html for and getting it to communicate with excel...

or guide me to step-by-step, how-to.... thanks

Try this http://blog.caspio.com/tech_tips/for...ta-into-excel/.
They have ways to get web form data into Excel.
Hope it helps

Originally Posted by Kyle123

Try that:

Please Login or Register  to view this content.

Kyle, Could you give us an example of using radio buttons and check boxes with this code?

Thanks!

I have a similar task as well. Ive created the sheet, however using the sample you suppled may not work.could you assist?

What doesn't work? Did you read the restrictions of this that I posted above?

Ps you need to start your own thread for this - we can't help you here