Code to Update Shared Excel Workbooks

[sethdromgoole]

Hi,

Does anyone know the VB code that will allow me to specify when a shared workbook is updated? I have built an application in Excel with userforms. The workbook needs to be updated when the user(s) navigate between various forms. I realize I can do this using the ActiveWorkbook.Save command; however, this is timely due to the writting to the disk. The Excel setting for automatic updates won't work because the minimum time is every five minutes. Any help would be greatly appreciated.

Thanks,

Seth

 

[PHV]

Take a look at the Saved property of the Workbook object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[sethdromgoole]

PHV,

That leads me to a question. Is updating the shared workbook basically the same as saving it? If so, I can just call the save method to update the workbook. However, I don't want to do this because as the file size grows, saving will become time consuming. Thanks for the help to this point!

-Seth

 

[PHV]

For me you have to use a REAL database instead of a big shared workbook ...