LinkBack URL
About LinkBacks
I've tried something as simple as :
This clearly won't work as this statement is exclusive to Word VBA.
Please Login or Register to view this content.
How would I go about saving and closing an open Word document, file name known, from Excel VBA?
I've tried something as simple as :
This clearly won't work as this statement is exclusive to Word VBA.Please Login or Register to view this content.
How would I go about saving and closing an open Word document, file name known, from Excel VBA?
Hi,
As long as you know the full path to the file, you might use GetObject thus
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
Hello xlnitwit ... thank you so much for your help. That worked wonderfully!
Last edited by Jenn68; 03-28-2017 at 10:08 AM.
OK ... looks like I also need to close Word after the document has been closed. My Google encounters haven't shown anything that appears useful in my case, so my guess is it's so simple I'm the only one having a need to ask.
Perhaps this
Please Login or Register to view this content.
xlnitwhit, this did work well. However, I do wish to save the document prior to closing it. I changed the .saved=true to .saved=false. I used DisplayAlerts to avoid the prompt.
What I am finding is that after this routine, WINWORD.exe is still an active process. Because of this, it may be messing with some of my other code, namely function code that checks to see if a document is open or not. As long as WINWORD is an active process, that function code always sees an open document when really there isn't.
Is there a far deeper rooted problem at play here?
It would be helpful to see all the code you are using.
Thank you.
This is quite a large project. I'll post the code that (I feel) reflects the bulk of Word document access.
This code is is triggered from a toggle button push on a userform. (uf4_works). It has been a challenge to explain how it is supposed to work, so I hope you are able to follow it.
The button can be in various states ...Please Login or Register to view this content.
1False ... Button not pressed, colour is RGB(176,196,222). This indicates no report (sRPT) has been previously created. Pressing it puts in into state 1True
1True ... Button pressed. Code picks up at the 'ELSE' statement, processes some code, before returning to the userform where the user can choose to view or print a merged document. It is here the sRPT is originally created and becomes accessible for future viewing with this same toggle button click.
2False ... Button not pressed, colour is RGB(0,153,211). This indicates that the report (sRPT) has been previously created and available for viewing. Pressing it will allow the user to access the sRPT document for viewing and/or editing.
2True ... Button is pressed. Launches a function to determine if the document is already open. If it is, nothing happens, other than turn the button colour purple indicating the file is already open.. If it isn't, this code will open it. Toggling from this state will close the document.
Third state should not be encountered other than during testing phases. It will have been a result of the button remaining in a 2True state before terminating the code voluntarily. The Word document opened remains open. When encountered, the document is closed.
Without this code, if the document remained open while attempting to access it again, the application would lock up. (Because the file is in use)
3False ... Button not pressed, colour is RGB(102,0,204). This indicates that the document is currently open. This will close the document.
3True ... allows the user to view
So, what I am experiencing, at the time the button is pushed, the document remains open and the button is purple. The document rRPT is successfully closed, the Word application quits, but there is still an instance of WINWORD.exe still in the process list. I am unable to open up the doc via 2True state. It is treated as though the document is already open.Please Login or Register to view this content.
Last edited by Jenn68; 03-28-2017 at 01:05 PM.
Change this
to thisPlease Login or Register to view this content.
Please Login or Register to view this content.
Wow. That was simple. Thank you again!
What kind of behaviour can I expect (an error?) if the user closes the document before returning to the userform and hits the button to trigger the code which would normally close the word document for them? Ideally, the user depresses the button (now in a true state), the document opens, they view/edit, and then return to the userform. Hitting the button again sends it to a false state causing the document to save and close. But if the document is no longer there, I sense an error.
While risking abusing your generousity, may I ask one additional question of similar nature?
On a separate button click, how could I close all existences of open Word documents, regardless of their names?
All is good. I answered my own questions after some trial and error.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks