Al

Change as below......

wkbk.SaveAs Filename:="M:\Spreadsheet\Text Files\" _
& rngName.Value & ".txt", FileFormat:=xlText

Gord Dibben Excel MVP - XL97 SR2 & XL2002

On 19 Jul 2003 23:24:28 GMT, (MrAlMackay) wrote:

All

The following is an extract of a macro / vba code that Tom has been able to
help me with.

Tom / All - would anyone be able to advise how I can make the text file to
actually be saved in a certain location instead of currently saving in the same
area that the xl spreadsheet is, e.g. instead of saving currently in same path
as the spreadsheet force it to save the text file in M:\Spreadsheet\Text Files

Below is the code:

Application.DisplayAlerts = False
wkbk.SaveAs FileName:=ThisWorkbook.Path _
& "\" & rngName.Value & ".txt", FileFormat:=xlText
Application.DisplayAlerts = True
wkbk.Close SaveChanges:=False

Thanks very much. Al ( )