yucatan 0 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 Share this post Link to post Share on other sites
somdcomputerguy 103 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. Share this post Link to post Share on other sites
JoHanatCent 13 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. Share this post Link to post Share on other sites
PsaltyDS 39 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 Share this post Link to post Share on other sites