[AccessD] Normal.dot file altered on close?

I've had a similar problem for a long time.  It was very bizarre and appeared mysteriously after invoicing runs.  The procedure processes all live projects, calculates the total value of all invoices by project to date and compares with a figure entered by project managers as work complete to date for any project on which we had performed work during a month.  Whenever there is a difference, it generates an invoice, statutory declaration as required and an envelope for each contractor being invoiced.  The routine saves a copy of the invoice in each project's invoicing folder and a duplicate in each regional monthly invoice summary for batch printing depending on selections the user made when running the process.  The NoSave argument isn't really an option except for the envelopes and I should have a look at that.

 

Anyway, the procedure ran nicely for several years and then suddenly started prompting to save changes to the normal.dot file for each document generated.  Kind of a pain when 120 - 200 documents are generated by the routine.  At one stage it was interrupting the automation process as well., refusing to allow new documents to be created until the matter of saving normal.dot was addressed  After numerous complaints that they had done something to break our system, the IT department finally somehow determined that the combination of their adding some custom toolbars to their version of normal.dot and OrgPlus having an option in the tools menu to also appear on the Word toolbars caused a conflict when Word was run in automation mode.  Given that they had locked down normal.dot and had inserted password protected code, the user was faced with several menus before he could cancel the save or navigate to a place where it couldn't be used anyway.  The fix to the problem, believe it or not, was to disable the 'Use OrgPlus in Word Menus' option in Org Plus.

 

After working smoothly for the next two years, IT installed a new version of OrgPlus and now we have the same automation problem with normal.do again, but so far it hasn't broken the automation code itself.  I have the users log into a 2nd vpn session and just disconnect it after running invoicing rather than having them deal with all the cancel save pop ups.  Probably not the best solution but if the IT boys cant be bothered to figure it out, I'll just have users crash sessions when it's convenient.


Ciao

Jürgen Welz

Edmonton, Alberta

jwelz at hotmail.com


 
> Date: Mon, 11 Oct 2010 09:35:40 -0700
> From: charlotte.foust at gmail.com
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Normal.dot file altered on close?
> 
> I seem to recall a NoSave argument to the close document operation.
> 
> Charlotte Foust
> 
> On Mon, Oct 11, 2010 at 9:18 AM, Rocky Smolin <rockysmolin at bchacc.com> wrote:
> > Dear List:
> >
> > I automated some customer response letter in my customer tracking system -
> > opens a word , inserts the contents into the body of an email, closes the
> > doc.  When the doc closes, though, I get a notice that normal.doc has been
> > altered do I want to save it, etc.  PITA because of course, I have to
> > respond to the prompts.
> >
> > What am I doing wrong?  The code's pretty minimal:
> >
> >
> >
> > Private Sub MakeMessage(argDocument As String, argSubject As String)
> >
> >
> >    Dim objWord As Object
> >    Dim objWordDoc As Word.Document
> >
> >    Dim objOutlook As Outlook.Application
> >    Dim objOutlookMsg As Outlook.MailItem
> >    Dim objOutlookRecip As Outlook.Recipient
> >    Dim objOutlookAttach As Outlook.Attachment
> >
> >    ' Get the body text
> >    Set objWord = CreateObject("Word.Application")
> >    objWord.Documents.Open (argDocument)
> >    objWord.Selection.WholeStory
> >    strBody = objWord.Selection
> >    'MsgBox strBody
> >    objWord.Documents.Close
> >    objWord.Quit
> >    Set objWord = Nothing
> >
> >
> > (code here to send email - working well
> >
> > End Sub
> >
> >
> >
> >
> >
> > MMTIA,
> >
> > Rocky Smolin
> >
> > Beach Access Software
> >
> > 858-259-4334
> >
> > Skype: rocky.smolin
> >
> > www.e-z-mrp.com <http://www.e-z-mrp.com/>
> >
> > www.bchacc.com <http://www.bchacc.com/>
> >
> >
> >
> >
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> >
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com