Save document, move to Downloads, quit Word

Alyb · #1 03-14-2025, 12:39 AM

I'm using Ms Word on my Mac and have a VBA macro that automatically fills in a form.rtf. I'd like to take the automation a step further.

After the information is filled in, the document should be moved to the downloads folder on my Mac (/Users/hl/Downloads) and then Ms Word should quit.

How can I accomplish this?

Thanks in advance!

Hans

macropod · #2 03-14-2025, 02:05 AM

Rather than moving the document, simply save it in your Downloads folder. For example:

Code:

ActiveDocument.SaveAs FileName:= "/Users/hl/Downloads/FileName.docx", FileFormat:=wdFormatXMLDocument, AddToRecentFiles:=False
ActiveDocument.Close
Application.Quit

Alyb · #3 03-14-2025, 02:23 AM

Thank you.
What would be the code to remove the rtf from the desktop afterwards?

macropod · #4 03-14-2025, 05:17 PM

I'm not familiar with the Mac OS, but in Windows, you'd use something like:

Code:

Dim StrNm As String: StrNm = ActiveDocument.Fullname
ActiveDocument.SaveAs FileName:= "/Users/hl/Downloads/FileName.docx", FileFormat:=wdFormatXMLDocument, AddToRecentFiles:=False
ActiveDocument.Close
Kill StrNm 
Application.Quit

Alyb · #5 03-14-2025, 11:38 PM

Thank you. That works!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word for Mac doesn't quit	Alyb	Word VBA	2	11-19-2024 12:37 AM
VBA to save word document as pdf to default location with inputbox to “save as” with filename sugge	richardgo	Word VBA	0	11-18-2020 09:36 AM
microsoft word doc downloads will not open	blabla20	Word	2	12-23-2014 07:50 AM
Word ask to save template whenever i save a derived document	jorbjo	Word	3	10-04-2012 10:52 AM
Word Crash on Quit	masomenos	Word	2	11-09-2010 12:35 AM