Hi everyone:
I'm trying to automate saving of all open documents in our computer room before performing a nightly installation of updates and a later reboot. For that I need first to save all open MS Office documents. The way I do it with most Office documents from an outside script is as follows:
Code:
var objAccess = GetObject("", "Access.Application");
//Then I'd enumerate all open documents in the .Documents property
//and call Documents.Item(n).SaveAs() method on each of them
But for some reason I can't do the same with MS Access. Can someone suggest how do I close all open documents in it with an option of saving them As in a file from a script?