Macro, auto refresh data

[Guest]

How can I write a VBA macro so it can refresh data anytime
when the excel book is opened?

Thanks
Daniel

 

[KLZA]

How can I write a VBA macro so it can refresh data anytime
when the excel book is opened?

Thanks
Daniel

Record a Macro and do your refresh thing. In VB, rename the macro to
Auto Start... It should look something like this..

Sub Auto_Start()
ActiveWorkbook.RefreshAll
End Sub

 

[KLZA]

Record a Macro and do your refresh thing. In VB, rename the macro to
Auto Start... It should look something like this..

Sub Auto_Start()
ActiveWorkbook.RefreshAll
End Sub

yikes! It's auto_open not auto_start

Record a Macro and do your refresh thing. In VB, rename the macro to
Auto Start... It should look something like this..

Sub Auto_Open()
ActiveWorkbook.RefreshAll
End Sub

 

[Guest]

Private Sub Workbook_Open()
me.RefreshAll
End Sub

placed in the thisworkbook module of your workbook.