Claus Busch wrote:

Hi Terry,

Am Fri, 31 Jan 2020 22:53:54 +0000 schrieb Terry Pinnell:

I included the data at the bottom of my 16:45 post and mentioned it at
the top:
"I copy tAll_VBA to the clipboard and use F5 to run your macro. (I've
also pasted a copy of that.)"

BINGO - I just successfully ran your macro! ;-)

I've no idea why yours works and mine didn't. It seems the only
difference in our workflow is that you are copying from a single cell of
a worksheet and I'm copying from my text editor. (I'm pretty sure I also
occasionally copied from a worksheet too, but one line per row.)

I've been up since 5:30 am so I'll get back on the case in the morning.

have a look:
https://www.dropbox.com/transfer/AAA...D3QOp0C 1y7E8

Into that folder is a text file and a new Workbook. The macro reads the
text file and write it into the workbook.


Regards
Claus B.

====================

Hi Claus,

Following my post early this morning I've made some progress. Could you
please download my queries here in WalkIndexLatestTest-FromClaus.xlsm

https://www.dropbox.com/s/vw5kgq36xy...aus.xlsm?raw=1

Best wishes,

Terry, East Grinstead, UK