yucatan Posted November 2, 2010 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
somdcomputerguy Posted November 2, 2010 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.
JoHanatCent Posted November 2, 2010 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.
PsaltyDS Posted November 2, 2010 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
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