Copy array into text file

F

Fabien

Hi,

I would like to find some array in a word document and to copy them into
a txt file (with tab instead of cell of course).

My input point is a text file with name of array to copy.
Array are referenced into list of table.

How can I do?

Thanks beforehand,

BR
Fabien
 
J

Jezebel

Assuming your array contains strings --

Dim pFileNum as long

pFileNum = freefile
Open "C:\MyFile.txt" for output as pFileNum
Print #pFileNum, Join(MyArray, vbtab)
close #pFileNum

If your array is not text, you'll need to iterate it.
 

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