Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save file as...
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
when i save xls file, debug script is running and canno't save fil | Excel Discussion (Misc queries) | |||
Excell2003 (SP-1) File > Save and File > Save As.. grayed out | Excel Discussion (Misc queries) | |||
Excel marcos firing on file save as but not file save | Excel Programming | |||
Save File to Another Directory, but not change Users File Save location | Excel Programming | |||
Save As - Multiple Sheets fails to save as text file | Excel Programming |