Thread
:
Query file without copy inside Excel
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Query file without copy inside Excel
What is the url? Have you tried an external query instead of the iqy?
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You send a clear explanation of what you want
3. You send before/after examples and expected results.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"JHH" wrote in message
...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett