Good Morning,

I need a bit of help exporting from Excel 2010 to a csv file.

Details:

My company uses an Excel workbook to quote our customer's components.

For every part we quote there is a copy of this workbook saved that GOES with each part.

My goal is to have each user run a macro that exports fields A3:BA3 from worksheet "DatabaseReport" upon completion of the quote to a centrally located csv file or another centralize workbook at location "c:\Quotes\Database\CommonQuoteTable.csv (xlsm) The macro must WRITE to an OPEN row so that any existing information that was populated by the same macro in a different copy of the quote workbook is not overwritten.

I will be using this "commonQuoteTable" in Access 2010 so if I can accomplish this by WRITING to an access table rather than a csv or spreadsheet would be ideal. However I spent a lot of time trying to find a way to do that without success.

I'm sure you can see the BENEFITS of having all of my quoted information in one location. I will be able to monitor success rates, query by customer, buyer, part size etc.

Thanks for any guidance you can give.

Chad
Pretty please with sugar on top??Never mind I figured it out.

On to a new problem. Looking up the last record in a csv file or access table to generate the next integer to use as a quote number.

Thanks,

Chad