Hello all,
I'm looking to save a file as a text delimted file. I have a bit of code
that reads like so:
ActiveWorkbook.SaveAs Filename:= _
"S:\SUPPORT\CADTAR\CMS\!Exported_Text_Files!\dMR.t xt",
FileFormat:=xlText, _
CreateBackup:=False

However, I need the file to read "d1525mr.txt. So, I need a "d" then get
1525 number from cell A1, tab INPUT_A and finaly at "MR".

Do able?

Thanks