Is there a way for "online" orders.

[Fotis1991]

Hi

I am not a programmer(Excel is my hobby) so my computers-network knowledge is real limited.

What i'd like to ask the specialists here is this.

Until now having created a Form in Excel, our salesmen-in other towns than Athens- email to the office this form as attachment for eatch of their orders and then a secretary copy and paste the orders to our Excel Base.

Does anyone knows a better way to do this?

Thank you.

[Mad-Mizer]

Hey Fotis, it sounds like you need an online order entry software. try looking into some software from the here.

[snb]

Put the ordering workbook on the server.
Provide each salesperson with a workbook in which a permanent link (Querytable) to the workbook on the server.
Add a small FTP macro into the workbook (2 lines), with which they can upload their adapted workbook to the server (password -could be their environ("computername") - to upload ftp-files provided in the macro and replace the workbook on the server.
Ready.
Everyone else can perceive the changes that have been made thanks to their updated Querytable.