code to convert xlsx to csv using vbscript

Question

can anyone please give me a code to convert xlsx file to csv using vb code

---

akhila

Answer 1

Hi SQL learner12,

Welcome to the MSDN forum.

Convertxlsx to csv is a FAQ.  So what do youneed, a VB.Net code or a VBScript code?

As this is a VB.Net forum, I’d like to share some information about VB.Net for you:

Convert xls file to a cvs file: http://social.msdn.microsoft.com/forums/en-US/vbgeneral/thread/dc7a7089-deea-4fc8-9eb0-49d7ea53098a/

Import data from XLS,XLSX,CSV,XML excel file to VB.NET: http://social.msdn.microsoft.com/Forums/en/vblanguage/thread/a8b58f9c-6dac-4074-96c5-ebe7a338aca6

Convert .xlsx & .xls to .csv: http://www.codeproject.com/Articles/246772/Convert-xlsx-xls-to-csv

The application in the last link is written in C#, I’d like to share the convert tool here: http://www.developerfusion.com/tools/convert/csharp-to-vb/

Hope this helps.

---

Mark Liu-lxf [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Thanks a lot for code.All these links were really helpful to me..thanks again

---

akhila