open workbook

[rbekka33]

my macros work ok now but when i add the line to open the workbook - i
does so successfully but then stops and doesn't run through the othe
macros i have called.

Sub xxx()
Workbooks.Open Filename:= _
"C:\Documents and Settings\person x\Desktop\Database.xls"
MatchData
ExtractUniqueEngCodes
CopyPasteUnique
End Sub

i also would like to automatically accept the "enable macros" dialogu
box which comes up.

is there any way of doing this?

cheer

 

[Tom Ogilvy]

One Possibility.
How do you run your xxx macro? Do you use a shortcut key that has a shift
as part of the combination? If so, use a shortcut key combination that
doesn't include a shift.