Updating Macro while Excel is closed

[karanrathod]

Hi all,

Is there any line item in VBA that we can add that will allow the macro to run and the file to update during times that the file is closed.

For example, I would like to update some data every two weeks, however, do not wish to keep opening this file and manually refreshing it.


Thanks in advance for any help.


Karan

 

[hiker95]

karanrathod,

Welcome to the MrExcel forum.

What version of Excel and Windows are you using?

Is there any line item in VBA that we can add that will allow the macro to run and the file to update during times that the file is closed.

I do not think so, but, see if the below link will assist you:

Programming The VBA Editor - Created by Chip Pearson at Pearson Software Consulting LLC
This page describes how to write code that modifies or reads other VBA code.
Programming In The VBA Editor

 

[JoeMo]

If you want to update the workbook itself (not the VBA code) look at the Application.OnTime Method when you visit the site Hiker95 has provided.