Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two Questions - Need help
I am programming excel to reterieve query tables as users select from
a drop down. That works fine. I did have to use an OnTime function to delay calling the next function while the query populates the table. Inconvenient, but not a problem However, When I try to make this available using a Summary Macro, calling the procedures in another sub obviusly does not pause the original Macro, 1) is there a way to pause and resume after a called macro is finished? (I want to the function, get the tables to populate and come back to the original For Next Loop) 2) Instead of Call MySub, can you get a call command to reference a cell with the Application.Run "'" & Range("X2") & "'" command. This works, s ok if no. But I need it to pause until Range("X2") is complete, which includes the user kicking of sql calls .onAction fom a dropdown I would paste code, but there is alot and my question is hopefully easy. Everything works, just not sequentially |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two Questions - Need help
Have you set
.BackgroundQuery=False This should delay actions until the querytable has been updated. wrote in message ups.com... I am programming excel to reterieve query tables as users select from a drop down. That works fine. I did have to use an OnTime function to delay calling the next function while the query populates the table. Inconvenient, but not a problem However, When I try to make this available using a Summary Macro, calling the procedures in another sub obviusly does not pause the original Macro, 1) is there a way to pause and resume after a called macro is finished? (I want to the function, get the tables to populate and come back to the original For Next Loop) 2) Instead of Call MySub, can you get a call command to reference a cell with the Application.Run "'" & Range("X2") & "'" command. This works, s ok if no. But I need it to pause until Range("X2") is complete, which includes the user kicking of sql calls .onAction fom a dropdown I would paste code, but there is alot and my question is hopefully easy. Everything works, just not sequentially |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two Questions - Need help
On May 14, 9:11 am, "Roger Whitehead" wrote:
Have you set .BackgroundQuery=False This should delay actions until the querytable has been updated. wrote in message ups.com... I am programming excel to reterieve query tables as users select from a drop down. That works fine. I did have to use an OnTime function to delay calling the next function while the query populates the table. Inconvenient, but not a problem However, When I try to make this available using a Summary Macro, calling the procedures in another sub obviusly does not pause the original Macro, 1) is there a way to pause and resume after a called macro is finished? (I want to the function, get the tables to populate and come back to the original For Next Loop) 2) Instead of Call MySub, can you get a call command to reference a cell with the Application.Run "'" & Range("X2") & "'" command. This works, s ok if no. But I need it to pause until Range("X2") is complete, which includes the user kicking of sql calls .onAction fom a dropdown I would paste code, but there is alot and my question is hopefully easy. Everything works, just not sequentially- Hide quoted text - - Show quoted text - Thanks! That removed the ontime within the called dropdwn macros. (Stupid I didn't catch that) However, I still need a way to pause a Initial macro while it calls the dropdwn macros Example Initial macro Code...do stuff x = variable for cnt = 1 to X call drpdownmacro(1,2,3,4,5,6,7,8,9,10,11,0r 12) next x will never be more than 5, but could be any possible combination of drpdwns 1-12 (user defined by dropdown selection) Any thought on pausing the Initial macro while users select the drop down for scenario 1 - X? Or is there a better way than looping and calling? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two Questions - Need help
Hi
I am trying to get hold of Roger Whitehead, a regular poster in this and many groups... Can anyone help with a contact email address as the one I have seems to be invalid? Many thanks in advance Vince On 14 May, 20:16, wrote: On May 14, 9:11 am, "RogerWhitehead" wrote: Have you set .BackgroundQuery=False This should delay actions until the querytable has been updated. wrote in message oups.com... I am programmingexcelto reterieve query tables as users select from a drop down. That works fine. I did have to use an OnTime function to delay calling the next function while the query populates the table. Inconvenient, but not a problem However, When I try to make this available using a Summary Macro, calling the procedures in another sub obviusly does not pause the original Macro, 1) is there a way to pause and resume after a called macro is finished? (I want to the function, get the tables to populate and come back to the original For Next Loop) 2) Instead of Call MySub, can you get a call command to reference a cell with the Application.Run "'" & Range("X2") & "'" command. This works, s ok if no. But I need it to pause until Range("X2") is complete, which includes the user kicking of sql calls .onAction fom a dropdown I would paste code, but there is alot and my question is hopefully easy. Everything works, just not sequentially- Hide quoted text - - Show quoted text - Thanks! That removed the ontime within the called dropdwn macros. (Stupid I didn't catch that) However, I still need a way to pause a Initial macro while it calls the dropdwn macros Example Initial macro Code...do stuff x = variable for cnt = 1 to X call drpdownmacro(1,2,3,4,5,6,7,8,9,10,11,0r 12) next x will never be more than 5, but could be any possible combination of drpdwns 1-12 (user defined by dropdown selection) Any thought on pausing the Initial macro while users select the drop down for scenario 1 - X? Or is there a better way than looping and calling? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Answers to questions posing more questions in a workbook | Excel Worksheet Functions | |||
Help with Look up questions | Excel Worksheet Functions | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
A few RTD Questions | Excel Programming | |||
two... two... two questions in one! | Excel Programming |