Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple web querys
I am having a web query in sheet1 (A1:E30) and it is based on a macro which
runs worksheet_change event.I am trying to add another 2 web querys to my sheet from f1:k25,these are not based on macros.Whenever I am trying to refresh these querys all are vanishing from my sheet and the first query results are coming twice or thice instead.Why ? how to resolve this problem? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple web querys
Need more info and post your code and say where the code is.
Web query properties change with Excel versions, what version are you using? Queries on the same sheet should have empty space between them. Mike F "TUNGANA KURMA RAJU" wrote in message ... I am having a web query in sheet1 (A1:E30) and it is based on a macro which runs worksheet_change event.I am trying to add another 2 web querys to my sheet from f1:k25,these are not based on macros.Whenever I am trying to refresh these querys all are vanishing from my sheet and the first query results are coming twice or thice instead.Why ? how to resolve this problem? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple web querys
Hello
You must select the range in the worksheet_change event because any change active the event -- J a c q u e s "TUNGANA KURMA RAJU" a écrit dans le message de ... I am having a web query in sheet1 (A1:E30) and it is based on a macro which runs worksheet_change event.I am trying to add another 2 web querys to my sheet from f1:k25,these are not based on macros.Whenever I am trying to refresh these querys all are vanishing from my sheet and the first query results are coming twice or thice instead.Why ? how to resolve this problem? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple web querys
In my Worksheet_change Event the code line is
If Target.Address< "$A$1" Then Exit Sub getit End Sub "Jacques ALARDET" wrote: Hello You must select the range in the worksheet_change event because any change active the event -- J a c q u e s "TUNGANA KURMA RAJU" a écrit dans le message de ... I am having a web query in sheet1 (A1:E30) and it is based on a macro which runs worksheet_change event.I am trying to add another 2 web querys to my sheet from f1:k25,these are not based on macros.Whenever I am trying to refresh these querys all are vanishing from my sheet and the first query results are coming twice or thice instead.Why ? how to resolve this problem? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple web querys
Dear Mike,
I am not an expert to vba and I am a layman to this forum.I don't know how to post code to in this reply.Even I don't know how to attach a workbook to this post.I have mailed my w/book to your e-mail address.Please look into it. "Mike Fogleman" wrote: Need more info and post your code and say where the code is. Web query properties change with Excel versions, what version are you using? Queries on the same sheet should have empty space between them. Mike F "TUNGANA KURMA RAJU" wrote in message ... I am having a web query in sheet1 (A1:E30) and it is based on a macro which runs worksheet_change event.I am trying to add another 2 web querys to my sheet from f1:k25,these are not based on macros.Whenever I am trying to refresh these querys all are vanishing from my sheet and the first query results are coming twice or thice instead.Why ? how to resolve this problem? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple web querys
I don't use mac but in xl2003right click table on web pageimport to
excelbuild from there. -- Don Guillett Microsoft MVP Excel SalesAid Software "TUNGANA KURMA RAJU" wrote in message ... I am having a web query in sheet1 (A1:E30) and it is based on a macro which runs worksheet_change event.I am trying to add another 2 web querys to my sheet from f1:k25,these are not based on macros.Whenever I am trying to refresh these querys all are vanishing from my sheet and the first query results are coming twice or thice instead.Why ? how to resolve this problem? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
querys from multiple sheets | Excel Discussion (Misc queries) | |||
Linking access tables, querys | Excel Discussion (Misc queries) | |||
view multiple files in multiple windows on multiple screens. | Excel Discussion (Misc queries) | |||
Default browser for web querys? | Excel Programming | |||
Macro that querys only the most current dBase file. | Excel Programming |