managing instances of Word
in [Word VBA]
|
Prev: Sub or Function not defined (Why ??)
Next: Printing first two pages in Tray 1 and subsequent pages in Tray 2
From: JR on 4 Jun 2010 19:39 is there such a thing? i'm running vba to open a new word doc from a template, do some stuff, save as pdf then close the doc if i quit the app via vba and other instances are running I get a this file is in use by another user, normal.dotm if i quite the app via vba and no other instances are running I get not error and word quits fine. this seems like an instance management issue? also if there are other instances are running, and i just close the doc and not quit the app in vba, everything is fine. when i go to close the app manually, i get the same normal.dotm error. its like word apps opened by me manually and by vba seemed to have different owners?
From: Doug Robbins - Word MVP on 3 Jun 2010 19:45 See the article "Control Word from Excel� at: http://www.word.mvps.org/FAQs/InterDev/ControlWordFromXL.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "JR" <iloveVBA(a)gmail.com> wrote in message news:uyDsNX3ALHA.5808(a)TK2MSFTNGP02.phx.gbl... > is there such a thing? > > i'm running vba to open a new word doc from a template, do some stuff, > save as pdf then close the doc > > if i quit the app via vba and other instances are running I get a this > file is in use by another user, normal.dotm > > if i quite the app via vba and no other instances are running I get not > error and word quits fine. > > this seems like an instance management issue? > > also if there are other instances are running, and i just close the doc > and not quit the app in vba, everything is fine. when i go to close the > app manually, i get the same normal.dotm error. > > its like word apps opened by me manually and by vba seemed to have > different owners? >
From: JR on 4 Jun 2010 20:57
That did it! Thanks! "Doug Robbins - Word MVP" <dkr(a)REMOVECAPSmvps.org> wrote in message news:%23QPqNb3ALHA.4400(a)TK2MSFTNGP05.phx.gbl... > See the article "Control Word from Excel� at: > > http://www.word.mvps.org/FAQs/InterDev/ControlWordFromXL.htm > > > -- > Hope this helps. > > Please reply to the newsgroup unless you wish to avail yourself of my > services on a paid consulting basis. > > Doug Robbins - Word MVP, originally posted via msnews.microsoft.com > > "JR" <iloveVBA(a)gmail.com> wrote in message > news:uyDsNX3ALHA.5808(a)TK2MSFTNGP02.phx.gbl... >> is there such a thing? >> >> i'm running vba to open a new word doc from a template, do some stuff, >> save as pdf then close the doc >> >> if i quit the app via vba and other instances are running I get a this >> file is in use by another user, normal.dotm >> >> if i quite the app via vba and no other instances are running I get not >> error and word quits fine. >> >> this seems like an instance management issue? >> >> also if there are other instances are running, and i just close the doc >> and not quit the app in vba, everything is fine. when i go to close the >> app manually, i get the same normal.dotm error. >> >> its like word apps opened by me manually and by vba seemed to have >> different owners? >> |