Automatically Save File

kgrabske · General User Joined: 11 May 2009 Posts: 5

I have a spreadsheet which I would like our manufacturing personnel to update periodically during the day. I would like to be able to view this spreadsheet (read-only) from my pc. My concern is that the person entering info into the spreadsheet will forget to click save, meaning that the read-only copy that I look at may not be up to date. Is there an extension or something that automatically the file to disk periodically?

Thanks,

Keith
_________________
Keith

Villeroy · Posted: Wed Sep 21, 2011 8:56 am Post subject:

A simple database would be the most elegant solution.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

kgrabske · General User Joined: 11 May 2009 Posts: 5

Villeroy,

I knew someone would suggest that. I was hoping for a down and dirty quick solution using a spreadsheet, because the development time would be minutes rather than hours.

I've tried to create a save macro and assign it to the "'Modified' status was changed" event, but my macro is unavailable for selection. Any thoughts as to why that would be the case?

Thanks,

Keith
_________________
Keith

Villeroy · Posted: Wed Sep 21, 2011 11:14 am Post subject:

Your request is explicit about daily usage with multi-user access and you do not want the users handle any documents.
A spreadsheet list would be a very quick one time solution where you may save 5 minutes of time and lose many hours over the weeks to come. Of course you can implement macros to imitate some database-ish mimicry. Nobody has ever be fired for writing bad Basic code.

http://www.oooforum.org/forum/viewtopic.phtml?t=113530
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

kgrabske · General User Joined: 11 May 2009 Posts: 5

I already have the save macro. I just need to get it to work from the "'Modified' status was changed" event. I need (or would prefer) to have the macro stored in the spreadsheet file itself as this would lend it portability. I suppose I could live with having to create the macro and assignment on each machine that would run this, but it seems like a pain. Any other thoughts?
_________________
Keith