Saving CSV file as a cell name

[scottymelloty]

Hi there

i have a macro that when i run it it saves Sheet 3 as Sel_FG.csv , i would like it to save Sheet 3 as the 1st 3 letters of cell A4 on ODDS Setup tab

This is the bit of code i already use, so it always saves that tab as SEL_FG.CSV i would like it to take the name it saves it by from Cell A4 on another tab which is called ODDS SETUP

Sheets("Sheet3").Select 
    ActiveWorkbook.SaveAs Filename:="P:\SEL_FG.csv", FileFormat:=xlCSV, _ 
        CreateBackup:=False  

any help would be great

thanks

[Ikaabod]

How about this?

Please Login or Register  to view this content.