I have a rather long URL-query in a file, "353.iqy". (The URL contains 353
characters)
I have let excel2000 write a macro which launches this query. Unfortunately
the resulting sheet saves the query inside itself under an ever 'increasing'
name . For the moment I manually go to external data , properties of table,
then unhatch the save the query and 'force' it to accept that, but next time
the internal name has become 353_2 f.inst. then next time 353_3 etc. which
means that the continuation of the macro that erases this query-table and
saves the file without macro and without query, just the data, cannot just
delete the query (as it has changed name).

Is it possible to include something in the query-file to avoid saving a copy
'inside' under a changed name ?

I tried of course to edit the inside file and no longer use the 353.iqy on
disk, but that often did not work because it exceeds the 254 character length
that excel readily accepts.
It seemed to work when started manually, but when started by scheduler at
the appropriate time it often failed.

Is this 254 character limit the same in excel2003 and 2007 ?

--
Yern