yucatan Posted November 2, 2010 Share Posted November 2, 2010 hello guys i wanne refresh all data in a excel sheet. so that it read the file and shows the data without closing and starting excel again. Thx Link to comment Share on other sites More sharing options...
somdcomputerguy Posted November 2, 2010 Share Posted November 2, 2010 There doesn't appear to be a refresh function in the Excel UDF, wouldn't the close and open functions kinda do the same thing? I don't use Excel, so I can't say for sure.. - Bruce /*somdcomputerguy */ If you change the way you look at things, the things you look at change. Link to comment Share on other sites More sharing options...
JoHanatCent Posted November 2, 2010 Share Posted November 2, 2010 All depends what refresh mean. Do you add data all the time to Exel and want to read this? Do you want to ReCalc? You also need to save Excel sooner or later. Link to comment Share on other sites More sharing options...
PsaltyDS Posted November 2, 2010 Share Posted November 2, 2010 Turning the automatic update off/on will force an immediate update: $oExcel.Application.ScreenUpdating = False $oExcel.Application.ScreenUpdating = True You might also use: $oExcel.ActiveSheet.Calculate Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now