I am in the process of updating an Excel project that includes a userform in which the user makes several sections from comboboxes and enters a few values into text boxes and these values are then input into a preformatted worksheet for printing.

After discussing it with the user, we concluded that with some of the changes I'm making, it wouldn't be necessary to physically print this report if there were a way to export it and pull the data up again later.

This leads me to the question of what would be the best way to go about doing this? Saving the sheets within the same workbook as the project isn't an option because we're talking hundreds, potentially thousands of sheets in a fairly short period of time.

It seems to me that the most efficient way to do this would be to export the data to a .csv file but I wanted to see what people with more experience handling such things thought. (I'm primarily a Visual Basic programmer. This is the first Excel/VBA project I've ever dealt with.)