Putting text files into an existing folder instead of a new one.

[Lymm]

Hi, I have been using Ron de Bruins code (below)to convert multiple text files to excel sheets in a newly added workbook. What I would like to do is to be able to add the worksheets to an existing workbook if possible. Help with the code for this would be much appreciated, Thanks


http://dl.dropbox.com/u/20269099/GetTextFiles.xls

 

[Luke M]

Assuming you are using the code from here:

http://www.rondebruin.nl/txtcsv.htm


You should change this line

[pre]

'Add workbook with one sheet
Set basebook = Workbooks.Add(xlWBATWorksheet)
to this

'Add workbook with one sheet
Set basebook = ActiveWorkbook

[/pre]
to have the sheets added to the currently active workbook.

 

[Lymm]

Brilliant , thank you, works a charm. I had been trying to put in the workbook name and obiously not doing it quite right as it didnt work

 

[Luke M]

Glad I could help. =)