Change location of where file is stored

  • Thread starter Thread starter MrAlMackay
  • Start date Start date
M

MrAlMackay

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 ( (e-mail address removed) )
 
Al

Change as below......

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

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Application.DisplayAlerts = False
wkbk.SaveAs FileName:="M:\Spreadsheet\Text Files\" _
& rngName.Value & ".txt", FileFormat:=xlText
Application.DisplayAlerts = True
wkbk.Close SaveChanges:=False
 
Back
Top