VBA save file with name

[sam]

Hi, 

On my VBA form I have inbox where I can paste a folder location. 

I have following code in my form rule that takes this string and saves the file.

strInputLocation = oLocation.Value
strBeamName = strInputLocation & "Part " & BoxName & ".ipt"
oDoc.SaveAs strBeamName, True
oDoc.Close True

Now file is saving alright, but there is problem with the location and file name.  Expected part name is Part 9.ipt inside New folder but it is saving in a higher level folder "box " adding New folder to the file name. (New folderPart 9.ipt). see below. 

any idea what is wrong. 

Best regards, 

sam

[JhoelForshav · Accepted solution]

@sam 

I think you're just missing a backslash...

strBeamName = strInputLocation & "Part " & BoxName & ".ipt"

should be:

strBeamName = strInputLocation & "\" & "Part " & BoxName & ".ipt"

[sam]

@JhoelForshav  Thank you so much for quick and helpful reply. have a good day. 🙂