Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I have a spreadsheet with a worksheet that I would like to create a CSV file from the worksheet. I would like to copy all columns data from A to L to the CSV file, only the records where date (Column D) greater than today, and not include hidden columns H and I. The first record in the worksheet starts on A10 and the first row of the CSV file should include the column names. Please help me create a script to complete this task. Example Worksheet Columns Names (Hidden) AT BT CT DT ET FT GT HT IT JT KT LT 20 ABV VB 12/20/07 CV GH 1221 34 45 HJ GF AS 60 AYT VB 11/22/07 CV GH 1111 45 66 HJ GF KY 70 FTY BT 12/22/07 GB HY 1233 44 88 JK YY OP 80 FFY BT 12/22/07 GB BB 1233 44 88 JK YY OP Desired Output F:\VBA\NMexico.CSV file AT BT CT DT ET FT GT JT KT LT 20 ABV VB 12/20/07 CV GH 1221 HJ GF AS 70 FTY BT 12/22/07 GB HY 1233 JK YY OP 80 FFY BT 12/22/07 GB BB 1233 JK YY OP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ecel:create a file name from data in worksheet | Excel Worksheet Functions | |||
create 50 copies of a worksheet in the same file | Excel Worksheet Functions | |||
How do I create a new worksheet using a template or xls file | Excel Programming | |||
Open CSV file, format data and write output to a text file. | Excel Programming | |||
Create a Worksheet by getting datas from the txt file with Macro | Excel Programming |