Query file without copy inside Excel

1234seng · 09-19-2009, 01:53 AM

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 ?

Regards

09-19-2009, 01:53 AM	#1 (permalink)
1234seng Registered User Join Date: Dec 2004 Posts: 55 OS: XP	Query file without copy inside Excel 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 ? Regards