Word files being overwritten when saved from excel.

[DouglasWicker]

Afternoon all,

I am running code that exports various tables and the like to a new word document. I then need to give the user the option to save this word file just like using the 'save-as' function in word. I have this up and running fine however I have two issues. Firstly if a file with the same name already exists, it will be overwritten. Any ideas? And I need to specify the default folder in which the folder dialog should open.

wdApp and wdDoc are both set as objects.

Any help is really appreciated. Thanks guys.

Code as below;

Please Login or Register  to view this content.

[ByteMarks]

You don't seem to be using the FileDialog, but the initial path is .InitialFileName

varResult which is the name used to save the file doesn't go though the GetNextAvailableName function. Maybe something like this:

Please Login or Register  to view this content.