Name and Save Document Using Defined Variables

Hi everyone, I wasn't sure if I should put this question under "Excel Programing" or "Word Programing"... I am writing this program in excel, but the program references the word object library.

WHAT I AM TRYING TO DO: This program I'm making defines variables based on the values of a couple specfic cells. I want to save a newly created word document that this program generates, using the variables as its name.

FOR EXAMPLE:

Please Login or Register  to view this content.

I thought that this might work, as it has with other things such as this:

Please Login or Register  to view this content.

Any help is appreciated!

odo-

Activedocument is a Word only object. It would work if you were writing the code in Word as it would be part of Word's Application object.

You can use Activedocument in Excel but only through an object which references the Word application.

Please Login or Register  to view this content.

I can only assume your routine ChangeFileOpenDirectory is not working properly.

With no path specified the file will be written to the active folder, which is the last one you browser to within the application. If you have not changed directory then the default starting folder will be used.

Simplest thing is to prefix the file name with the path when saving.