Claus Busch wrote:
Hi Terry,
Am Sat, 01 Feb 2020 14:12:28 +0000 schrieb Terry Pinnell:
That is an interesting alternative to the external clipboard approach.
(I used a similar method, but with tTtrackName.xlsm as my source.)
But your macro would need the varying file name tTrackName.txt, which I
assume that would have to be passed via the clipboard anyway?
The actual text files I create look like this one for 20190714Fowey to
Polperro-r925-m8.3.txt are more extensive.
https://www.dropbox.com/s/n300ncvxmu...m8.3.txt?raw=1
My MX macro then parses and summarises the file as tAll_VBA, which is
then used by your macro. (Version N - I'm losing track)!
I'm very happy with the external clipboard approach, not only because it
capitalises on the work I've already finished but also because it's
almost finished, thanks to your patient efforts!
have another look in DropBox
Regards
Claus B.
Sorry Claus, I don't follow? Look at what? You've not given a Dropbox
link.
Terry, East Grinstead, UK