Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 07-13-2012, 07:53 AM
Jirik61 Jirik61 is offline Refresh of data from external source Windows XP Refresh of data from external source Office 2007
Novice
Refresh of data from external source
 
Join Date: Apr 2012
Posts: 8
Jirik61 is on a distinguished road
Default

Dear Paul,

Thank you for your hint, I made some test in the past and used a couple of commands for delay or wait until keypress, but I failed.
For instance - when I used the MsgBox statement, the aplication update nothing until I press the key...

for refresh I used :

Application.Calculation = xlManual
mustek.RefreshAll
Application.Calculation = xlAutomatic


and then :

Application.Wait (Now + TimeValue("0:00:20"))


or : MsgBox "Akualizce", vbOKOnly

If I debug the application (Step Into) the data are refreshed correctly, and I am not able to make a "step forward" until the data are refreshed completely.
Do you have any idea?

Thanks!
Jirik
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Refresh of data from external source drop down list from external data source Excel 2007? Intruder Excel 1 08-03-2012 05:41 AM
Refresh of data from external source vba change external data source excelledsoftware Excel Programming 1 07-17-2012 04:22 AM
Refresh of data from external source Automatically Selecting a Data Source Nathan_Newlin Mail Merge 1 12-06-2011 03:42 PM
Edit Data Source- Linking template charts to new data lbf PowerPoint 0 10-28-2011 12:19 PM
Help w/ external data bellest Excel 0 11-11-2005 12:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft