Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
New CSV File
Hello,
Looking for code to. Take Tab Name "Kitting Output" and turn it into a .CSV file named HLP with todays date on the end. Example HPL112806. And then save it to the desktop. Thanks in Advance. Aaron |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
New CSV File
Aaron
Try this: Sub csv() On Error GoTo error_line Sheets("Kitting Output").Copy ActiveSheet.SaveAs _ Filename:="HLP" & Format(Now, "ddmmyy") & _ ".csv", FileFormat:=xlCSV, CreateBackup:=False ActiveWorkbook.Close savechanges:=False Exit Sub error_line: MsgBox "Error saving file, check", vbOKOnly End Sub -- Hope this helps Martin Fishlock "Aaron" wrote: Hello, Looking for code to. Take Tab Name "Kitting Output" and turn it into a .CSV file named HLP with todays date on the end. Example HPL112806. And then save it to the desktop. Thanks in Advance. Aaron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File:1 and File:2 -- Double Files when Opening One File | Excel Discussion (Misc queries) | |||
I saved file A over file B. Can I get file B back? | Excel Discussion (Misc queries) | |||
opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
I SAVED A FILE OVER ANOTHER A FILE IN EXCEL. THE OLD FILE WAS AN . | Excel Discussion (Misc queries) | |||
i received a file that reads powerpoint document file file exten. | Excel Discussion (Misc queries) |