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 ( )

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 ( )

Application.DisplayAlerts = False
wkbk.SaveAs FileName:="M:\Spreadsheet\Text Files\" _
& rngName.Value & ".txt", FileFormat:=xlText
Application.DisplayAlerts = True
wkbk.Close SaveChanges:=False

--
Regards,
Tom Ogilvy


MrAlMackay wrote in message
...
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 ( )