Auto Run (upon opening) 2 macros in sequence

[plsbegreen]

Hi,
My goal:
Upon opening an excel file, using "Auto_Run" macro run "macro1" - when COMPLETE, THEN run "macro2"

I attempted the "call" method and still, the "remove duplicates macro" completes before the query refresh.
The query refresh takes time - I need this to complete before the duplicates are removed from the sheet named "Starlims".

macro1 is named as "RefreshAll"
macro2 is named as "Refresh2"


my two SEPARATE macros:

Sub RefreshAll()
'
' RefreshAll Macro
'

'
ActiveWorkbook.RefreshAll

End Sub
_________________________________________________________________________________________

Sub Refresh2()
'
' Refresh2 Macro
'
' Keyboard Shortcut: Ctrl+d
'
Sheets("Starlims").Select
ActiveSheet.Range("Table_Query_from_DWH[#All]").RemoveDuplicates Columns:= _
Array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, _
28, 29, 30, 31, 32, 33, 34), Header:=xlYes
End Sub


Please help! Thank you

[pjwhitfield]

In your Workbook_Open event put:

ActiveWorkbook.RefreshAll
Sheets("Starlims").Select
ActiveSheet.Range("Table_Query_from_DWH[#All]").RemoveDuplicates Columns:= _
Array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, _
28, 29, 30, 31, 32, 33, 34), Header:=xlYes

[plsbegreen]

@pjwhitfield, this did not work. Both macros ran simultaneously and since the "remove duplicates" takes less time, the duplicates were removed before the queries were refreshed.

In your Workbook_Open event put:

ActiveWorkbook.RefreshAll
Sheets("Starlims").Select
ActiveSheet.Range("Table_Query_from_DWH[#All]").RemoveDuplicates Columns:= _
Array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, _
28, 29, 30, 31, 32, 33, 34), Header:=xlYes