Hi,
Is it possible for an excel spreadsheet to update a html file or maybe some type of database through a macro?
What I am trying to do is create a simple OMS that uses a spreadsheet as the input and stores the consolidated data on ex. a html page
Ex.
User A puts in an order for 20 Fish and 15 Lobsters
User B puts in an order for 20 TVs
Both user A and B do this on their individual spreadsheets.
The final result is that both the orders of user A and user B are visible to user A, B and C on a html based page that is stored on the network and automatically updated.
(Ultimately I also want to be able to tick off the orders on the page itself as they are filled)
I don't have much experience outside of the realm of excel & VBA so if anyone could point me in the right direction that would be great.
Thank You!
maks
Is it possible for an excel spreadsheet to update a html file or maybe some type of database through a macro?
What I am trying to do is create a simple OMS that uses a spreadsheet as the input and stores the consolidated data on ex. a html page
Ex.
User A puts in an order for 20 Fish and 15 Lobsters
User B puts in an order for 20 TVs
Both user A and B do this on their individual spreadsheets.
The final result is that both the orders of user A and user B are visible to user A, B and C on a html based page that is stored on the network and automatically updated.
(Ultimately I also want to be able to tick off the orders on the page itself as they are filled)
I don't have much experience outside of the realm of excel & VBA so if anyone could point me in the right direction that would be great.
Thank You!
maks
