looks great - how can I add the heading on each CSV?
looks great - how can I add the heading on each CSV?
What do you mean by "Heading"?
Do you mean feild names?
sorry - feild names please
After this line
Open "C:\Access Databases\" & groupname For Output As #1
paste in this line of code
Write #1, "First Name, Last Name, UserName, Group" & vbLf
looks great - just a question when I open the CVS in Excel the field names are in cell a1 and the othe data in cell b1 and so on - see screen shot.ScreenShot014.bmp
That is normal for CSV, you have to parse the data using Excel's Data> Text to Columns.
Or you use a Data>import from text to convert it as it cis imported.
thank you - have a great weekend