Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hide columns when saving csvq
In Excel 2007, is there a way to save a file to a csv file without certain
columns. I tried hiding columns D and E, which it does, but when I saved as a .CSV file - it saves the columns I hid as well. Thanks, Tom |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hide columns when saving csvq
Don't know about 2007 but this works in 2003. I'm sure the experts can make
or more simple version of this code. Sub CopyVisCells() Dim ThisDate As Date, myDate As String, myfile As String 'you might like to change this to 'myfile = activesheet.name 'remove the comma at beginning of line and ' rem or delete next line myfile = "ShortRept" ThisDate = Int(Now) myDate = Day(ThisDate) & "-" & Month(ThisDate) & "-" & Year(ThisDate) myfile = myfile & " " & myDate MsgBox myfile Application.DisplayAlerts = False Range("A1").Select Selection.SpecialCells(xlCellTypeVisible).Select Selection.Copy Workbooks.Add ActiveSheet.Paste Range("A1").Select Application.CutCopyMode = False ActiveWorkbook.SaveAs Filename:= _ "C:\Documents and Settings\Peter\My Documents\" & myfile, FileFormat:=xlCSV, _ CreateBackup:=False ActiveWorkbook.Close Selection.CurrentRegion.Select Selection.EntireColumn.Hidden = False Cells(1, 1).Select Application.DisplayAlerts = True End Sub "tshad" wrote: In Excel 2007, is there a way to save a file to a csv file without certain columns. I tried hiding columns D and E, which it does, but when I saved as a .CSV file - it saves the columns I hid as well. Thanks, Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HIDE COLUMNS | Excel Discussion (Misc queries) | |||
Hide/Unhide columns using button on top over relevant columns | Excel Discussion (Misc queries) | |||
Hide some columns? | New Users to Excel | |||
Saving Into Columns ? | New Users to Excel | |||
Cannot Hide Columns | Excel Discussion (Misc queries) |