Hidden rows still visuale under CSV

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Robert Christie (anonymous_at_discussions.microsoft.com)
Date: 04/22/04 

Date: Thu, 22 Apr 2004 04:22:03 -0700

Hi Gestron
The file Extension .CSV stands for Comma Separated Values.
When you save an Excel .xls file as a .CSV file only the
formula values are saved the formulas are lost, all
formatting like hidden rows and columns is lost, replaced
with all the cell values separated by a Comma.
I believe it's a common way of transfering raw data from
one application to another.
The file size is much smaller as well.
Just save your file as an Excel Workbook with a filename
followed by the .xls extension and any changes you make
will appear next time you open the file..

HTH
Bob C.

>-----Original Message-----
>Dear All,
>
>I'm using Office 97, I've 2 macros : a) hide the rows
with amount value
>zero and b) automatic save the sheet to local drive with
a
>csv-extension. But, when the sheet is saved I noticed
that in the new
>file the hidden rows are still visual. How to avoid
these lines ????
>
>Used code (a) Hidden rows :
>
>Sub hide_rows()
>Dim RowNdx As Long
>Dim LastRow As Long
>
>LastRow = ActiveSheet.Cells(Rows.Count, "W").End
(xlUp).Row
>For RowNdx = LastRow To 1 Step -1
>If Cells(RowNdx, "W").Value = 0 Then
>Rows(RowNdx).Hidden = True
>End If
>Next RowNdx
>End Sub
>
>Used code (b) save to csv :
>
>Sub export_csv()
>
>ActiveSheet.Copy
>ActiveWorkbook.SaveAs FileName:="C:\Temp\Upload.csv",
>FileFormat:=xlCSV, CreateBackup:=False
>ActiveWorkbook.Close SaveChanges:=False
>
>End Sub:confused:
>
>
>---
>Message posted from http://www.ExcelForum.com/
>
>.
>

Relevant Pages

  • Re: GetObject - Outlook/Excel 2007
    ... Excel 2007 is capable of opening an existing .xls file. ... tells you the file extension is registered properly and pointing to Excel. ... Author of Microsoft Outlook 2007 Programming: ...
    (microsoft.public.outlook.program_vba)
  • Process needs refining, please assist at question
    ... Select the csv file to open ... Open the csv file in Excel with Access still running in the ... usable data in it, save the file as an xls File, close Excel) ... Select the file name created above (filename gets stored in text ...
    (microsoft.public.access.modulesdaovba)
  • Excel ActiveX SaveAs interface
    ... I'm trying to write a program in matlab that will have excel create a CSV file based on an existing spreadsheet, but I'm having trouble coaxing the activex interface into saving an xls file as a csv file. ... invoke(exsheet,'SaveAs',{'myfile.csv', 'xlCSV'}) %writes an xls file to myfile.csv, and writes xls to xlCSV as well ...
    (comp.soft-sys.matlab)
  • Disabling some MS Excel warnings.
    ... I have a .xls file that presents a graph from an external .csv file. ... it set to refresh the external data automatically on reopening the .xls file. ... It works fine for the most part but Excel gives me two warnings everytime I ...
    (microsoft.public.excel.misc)
  • Re: "file" cannot be accessed
    ... to a nice filename with .xls file extension -- if you find one, ... My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm ...
    (microsoft.public.excel.misc)