Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Saturday, 11 November 2017
  1 Replies
  5.6K Visits
0
Votes
Undo
Hi All,

This is my first question at this forum because I come across a real head scratcher..

I am trying to adapt a VB code, published at https://www.extendoffice.com/documents/excel/3388-excel-import-multiple-text-csv-xml-files.html#a2 to import multiple CVS files from the same directory and place them transposed into a single Excel worksheet.

The source files are all located in the same folder.
There are 3 columns of data in the source files, but only 1 column need to be imported,
The imported data is to be transposed and placed in the next empty row on the target worksheet.

My modified code is so messy that I do not even want to paste it here,but you can find two sample input CVS files and a desired output XLSX file attached.

Thanks for all help in advance.
6 years ago
·
#1319
0
Votes
Undo
Hello,
Sorry, we don't have such function yet.
Please try to post your question after the article.
The author may try to help you.
  • Page :
  • 1
There are no replies made for this post yet.