Hi All,
We are running on NW2004s, the requirement is that the excel sheets should be available on the portal.
Here are the steps that the users are going to follow.
1. Log on to portal.
2. Click on a link that opens a iview which has an excel sheet.
3. This excel sheet that opens up should be there on the portal as a template.
Which means that the excel sheet can store data and be saved with that data AND macros on the
portal (probably in a KM repository).
4. The user hits the SUBMIT button and the data in the excel sheet gets stored in the backend tables.
5 After a month, the user again opens that excel sheet template with the stored data and macros,
CHANGES THE DATE and some other (minimal) values and hits the submit button again .
6. The data gets stored in the backend systems.
The whole idea is to get the users use the same excel template WITH THE SAVED DATA AND MACROS and a little bit of changes every month and post the data through the portal.
Any suggestions will be appreciated.