Open a TXT file while exiting Word VBA

[Robie]

Hi

This is probably a stupid question - so apologies in advance.

Is it possible to open a file (in this a text file) as the last thing in a VBA macro and exit Word VBA? Basically, I am trying to open a text file after completing some VBA work.

Thanks.
Robie.

[StuartR]

Just include something like

Code: Select all

    Dim fileTextfile
    fileTextfile = Shell("C:\WINDOWS\notepad.exe C:\folder\filename.txt", 1)

before the end of your macro

[HansV]

And add

Application.Quit

if you want to exit Word. If you want to save any open and modified documents, use

Application.Quit SaveChanges:=True

If you want to close all open documents without saving changes, use

Application.Quit SaveChanges:=False

[StuartR]

Hans,

I assumed that the intention was to exit VBA, rather than to exit Word

[HansV]

I agree that that's what Robie requested. But just in case he meant something else...

[Jay Freedman]

And if you want to open the text file in Word instead of in Notepad, put this line last in the macro:

Code: Select all

Documents.Open "C:\folder\filename.txt"

[Robie]

Apologies for late reply but wasn't around until today.

Thank you Stuart, Hans and Jay.

I went with Stuart's suggestion as it works for me wonderfully.

THANK YOU VERY MUCH -