Visual basic 2013 excell to csv

Hello Experts,
I've got a Little more tan one hundred excell workbooks, each with around fifty worksheets,
I need to store each sheet as a csv to be uploadad by our App

how can I open an existing excell workbook and save all if its worksheets in csv format ?

REgards,

Microsoft ExcelVisual Basic.NET.NET ProgrammingVBA

Last Comment

RGuillermo

8/22/2022 - Mon

Qlemo

4/28/2015

There are many ways to do that. As I assume adding VBA code to each workbook is no option, you'll best use a "master" Excel file containing the code. Or VB Script, or PowerShell.
How are you getting the list of workbooks to process? All workbooks sitting in a specific folder, for example?

RGuillermo

4/28/2015

ASKER

Qlemo, yes all workbooks in same folder.

ASKER CERTIFIED SOLUTION

Qlemo

4/29/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial