Hi Garry,
Replies inline.
GS wrote:
GS wrote:
GS wrote:
Hi Terry,
Am Fri, 31 Jan 2020 18:31:33 +0000 schrieb Terry Pinnell:
I'm still struggling to find what I'm doing wrongly with Claus's last
code, but I think I'll put it aside for now and retire to the lounge for
a glass of white ;-)
you get the error when the cipboard is empty.
Regards
Claus B.
I got the same error running with an empty Clipboard! This is my
contention for going with reading the source data directly into an array
and processing it entirely within Excel with no external dependencies!!
Hi Garry,
OK, here's some typical 'source data'
https://www.dropbox.com/s/kwb4yy02rw...m8.3.gpx?raw=1
I'm looking forward to seeing and using your code, delivering all the
output I get from my MX Pro macro, text and images. Using your "very
simple approach"!
Terry, East Grinstead, UK
Thanks!
This is an XML file that has 4,846 lines of data (including blanks), which
will easily parse with any XML parser utility. Fortunately, this is
available to VB[A] already because many years ago XML became the standard
for storing data as plain text files and processing doesn't have the
overheads associated with a full-blown database.
Sounds good so far. Time will tell!
I will only be proposing a solution for pulling the data into your worksheet
similar to you do now
Just to be su I assume you mean the WalkIndex.xlsm workbook,
worksheet Target. As I reminded you, I no longer make the 'track sheet'
workbooks.
I asked for the current worksheet template[s] you now use in WalkIndex.xlsm!
There is no 'template'. Just what you see.
and what GPSU does into its view windows. Although I do
use PSP for processing ScreenCaptures, I'm afraid you'll have to do your map
processes same as you now do. (Assuming the images you refer to are not
bundled with the file data on the clipboard)
Ah, I thought the idea was that you could do it *all* in VBA? Starting
with the GPX and ending with the extra data added to WalkIndex.xlsm?
Yes, that is correct. What am I (or you) missing that you ask this? I still
haven't gotten from you the design description and project intent so perhaps
I'm at a disadvantage for fully understanding this project beyond what your
WalkIndex.xlsm reveals.
I've answered those in the post in which you raised them.
Yes, of course you're at a disadvantage, I'd say a serious one! Just as
I am with this 1% of the project because I'm not a VBA programmer, so
you are with the previous 99% because you don't know GPSU.
But we're now way OT! If you want to discuss GPSU there's a Google group
forum at
https://groups.io/g/gpsu/ but it's been pretty quiet for the
last few years and traffic dropped off even more sharply when it moved
to Google after Yahoo dropped its groups.
Is this the GPSU output format for spreadsheets?
Sorry, don't understand that last question. GPSU doesn't have 'an output
format for spreadsheets' per se, but CSV is often used, although not by
me.
Well since WalkIndex.xlsm IS a spreadsheet I'd think the data should be in
GPSU's CSV format since XML parsing carries way more overhead than parsing a
simple delimited text file.
Terry, East Grinstead, UK