View Single Post
 
Old 03-08-2018, 02:39 AM
rosscortb rosscortb is offline Windows XP Office 2010 32bit
Novice
 
Join Date: May 2014
Posts: 17
rosscortb is on a distinguished road
Default

Hello,

I have been using the above code in my document and in other documents and it is working fine. However, even though it works in others in now seems to be not working in my contract document, the only thing I have done different is change the strPath to be saved in the 2018 folder instead of the 2017 one.

So the code now is
Code:
Dim fileName As String
Const strPath As String = "H:\HR\Reward & Shared Services\Shared Services Only\1 ~ Starters\5 ~ Offers Sent\2018 Offer of Employment Sent"
fileName = txtLastName.Value & "," & txtFirstName.Value & " - Contract"
With Dialogs(wdDialogFileSaveAs)
  .Name = strPath & fileName
  .Show

 
End With
What happens now is instead of the save as Dialog popping up and displaying LastName,FirstName- contract, it says 2018 Offer of Employment Sent LastName.FirstName -contract

Also, it doesn't save in the strPath but one folder before so
H:\HR\Reward & Shared Services\Shared Services Only\1 ~ Starters\5 ~ Offers Sent

Regards

Ross
Reply With Quote