Macro, auto refresh data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

Thanks
Daniel
Click to expand...

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
 
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
Click to expand...

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
 
Private Sub Workbook_Open()
me.RefreshAll
End Sub

placed in the thisworkbook module of your workbook.
 
Back
Top