Hi,
I want to read the data from a worksheet in an excel workbook, write it to a new worksheet and save that as a dbf or csv file (one worksheet)...basically extracting worksheets from a workbook and saving them individually, renaming them as the title of the worksheet with the title of the workbook (either one first).
What I have tried to do (I don't have the code on me right now)
is read each column in the worksheet and write it to a new file, but I get all of the 5 columns from the original file written to the A column of the new file. How can I start each column at the top of the appropriate column, or is there a better way to do it?
I can post the code later if need be...Thanks.
