Sign in to follow this  
Followers 0
yucatan

refresh excel

4 posts in this topic

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



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

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

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

:graduated:


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

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0