I have a bunch of CSV files i exported from a database. What i need to do is combine all of these CSV files into 1 excel workbook with like 10 worksheets. This is possible i believe but im not sure how to do the excel piece. Any tips will be apprciated. Thanks.
Using Excel
- Thread starter bjr149
- Start date
DavidT_macktool
Well-known member
Here is a link to help get you started:
http://www.vbdotnetforums.com/showthread.php?t=10009&highlight=excel
make sure you do the following also.
Add references for both Excel (v. 9 for 2000, v. 10 for XP) and Office (same).
Solution Explorer => highlight 'References' => right click and choose add references. Choose from the COM tab to find Microsoft Excel 10.0 and Microsoft Office 10.0.
at the top of the form add:
Imports Excel
http://www.vbdotnetforums.com/showthread.php?t=10009&highlight=excel
make sure you do the following also.
Add references for both Excel (v. 9 for 2000, v. 10 for XP) and Office (same).
Solution Explorer => highlight 'References' => right click and choose add references. Choose from the COM tab to find Microsoft Excel 10.0 and Microsoft Office 10.0.
at the top of the form add:
Imports Excel
Similar threads
- Question
