Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting to CSV or Text files with variable ranges on a worksheet
Hi. I've tried finding solutions from the myriad previous postings on
similar subjects, but find myself even more confused! (Am almost a complete novice in VBA.) My problem is that I need to create a csv file in Notepad that contains a header of 4 fields structured as follows: Indicator Date/Time User ID Batch # CI 20050705123222 nmorse 1 A footer that contains 3 fields structured as follows: Indicator Total # Records Hash Total 99 7 100.000 and a body that contains a variable number of row entries, each row contains 16 fields, some of which are not compulsory, but the output requires the consecutive delimiters (without empty strings)for the empty column fields. The date and time in the header needs to be created at the time of the entries into the body in the format yyyymmddhhmmss (which is also causing me a problem or two) and the total records and the hash total are the count and sum of the variable number of entries made into the body part of the worksheet, so I can't just hardcode these values somewhere to use each time. The userId can be generated by using the Windows userId so that's not a problem (I'm pretty sure I can handle). The batch # needs to be sequential dependent on the number of files generated by each user, each day. I've structured my worksheet as outlined above. Admitting defeat on this. All help greatly appreciated and gratefully accepted! Cheers Neale |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Naming Ranges for data exporting | Excel Discussion (Misc queries) | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
Exporting to CSV or Text files with variable ranges on a worksheet | Excel Programming | |||
Importing/Exporting text files and string editing | Excel Programming | |||
Exporting CSV files | Excel Programming |