Wednesday, 11 September 2013

VBA Word - Using a userform object to save a file

VBA Word - Using a userform object to save a file

I need to have the VBA code save a file, that was created from a template,
to a specific directory with a specific name. Example: \Partial path\ plus
a subdirectory selected in the userform \ plus another bit of info from a
different userform. I can get it to save to the partial path, but adding
the subdirectory and the filename is where I'm stuck. This was the last
thing I tried...
ActiveDocument.SaveAs2 FileName:="X:\Directory\" & strSubDirectory &
strUserText ".docx"
Any help would be greatly appreciated.

No comments:

Post a Comment