rnpjen
11-23-2007, 08:18 PM
I am truly a beginner here, so I hope someone can help me.
I have created an internal website for my company that includes links to all of our quality documents (combination of Word, Excel & Acrobat files). Several of the Excel documents are active logs that all employees enter information into.
When a user clicks on a link, the document opens in Excel, data is entered, then the user attempts to close the file. The user is prompted to save the file (they have been instructed to always choose yes unless they don't want to save their changes).
The problem is when the file is opened from the website, it opens as a temp file so when the file is saved, it saves in a temp folder instead of the original location. My users are beginners and have lots of trouble having to navigate to save files, so having them save before they close would be difficult.
From what I have read here on this site, it seems that I can have a script run before closing that will save the file in a specified location and as a specified name.
I have tried using some of the code that has been posted in other threads here but can't seem to get the correct result, probably because I don't know what I'm doing.
I hope someone can help and that I have given enough information.
Thanks.
I have created an internal website for my company that includes links to all of our quality documents (combination of Word, Excel & Acrobat files). Several of the Excel documents are active logs that all employees enter information into.
When a user clicks on a link, the document opens in Excel, data is entered, then the user attempts to close the file. The user is prompted to save the file (they have been instructed to always choose yes unless they don't want to save their changes).
The problem is when the file is opened from the website, it opens as a temp file so when the file is saved, it saves in a temp folder instead of the original location. My users are beginners and have lots of trouble having to navigate to save files, so having them save before they close would be difficult.
From what I have read here on this site, it seems that I can have a script run before closing that will save the file in a specified location and as a specified name.
I have tried using some of the code that has been posted in other threads here but can't seem to get the correct result, probably because I don't know what I'm doing.
I hope someone can help and that I have given enough information.
Thanks.