VBA Novice

gmayor · #9 07-02-2018, 10:45 PM

You could change the section in the code to

Code:

With Dialogs(wdDialogFileSaveAs)
     .Name = "V:\Inspections\2018\" & strName
     .Show
 End With

or you could replace that with

Code:

ActiveDocument.SaveAs2 "V:\Inspections\2018\" & strName

which will save the file without displaying the dialog, but it will overwrite an existing file of the same name and will crash if the folder doesn't exist.

You will find CreateFolders and FileNameUnique code on my web site to overcome these issues.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Recommended Reading for Novice	callasabra	Word VBA	3	07-06-2014 10:36 AM
Please help this novice.	cupofjoe1962	Excel	2	09-16-2013 12:17 PM
Chart novice - help required	clanger32	Excel	1	04-12-2012 09:35 AM
VBA Novice having problems with colours.	Simoninparis	Excel Programming	2	02-29-2012 03:28 AM
Two questions from a novice	alexB	Word	0	08-11-2010 08:47 AM