Hi<br>
<br>
Can anyone help? In Excel I am using VB code to Refresh a query table to an Access Database. However, Excel will not redraw the spreadsheet with the external data unless I come out of the procedure. I need to do other things in this procedure after it gets the data. I am using...
Hi Barryg<br>
<br>
As you probably know there is no method to count visible workbooks. However, try this routine and I hope it works<br>
<br>
<br>
Sub VisibleWorkbooks()<br>
'Count the number of Open Workbooks<br>
vopenworkbooks = Application.Windows.Count<br>
vvisible = 0<br>
'Loop to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.