exporting a multiple sheet worksheet to text

A

anne001

I would like to export a multiple worksheet excel data to text.

CVS will not export multiple worksheets all at once and at
50 sheets or more * 50 files I don't want to do this work by hand.

I found
excel to SAS a super long macro I don't want to deal with
excel to R a package which does not load succesfully in R
excel to matlab, a function xlsread which does not work on a mac
excel to Ruby, a function with a 'require' calling for a PC package...

I can, I suppose figure out how to write a macro in excel
or install matlab on a pc
or figure out how to install and run ruby on a pc.

Is there something simpler I can do? Is there no way for excel to
export data to text, even if it is multiple sheet? Even if it requires
an intermediate step like folding all the sheets into one
(like merging layers in photoshop)?
 
D

Douglas J. Steele

You'd stand a better chance of getting an answer if you ask in a newsgroup
related to Excel.

This newsgroup is for questions about converting data to and from Access,
the database product that's part of Office Professional.
 
A

anne001

Ok, I had taken the word access in the generic sense.

By the way if somebody has such problems and is working with access,
, access seems to have an append fx which might help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top