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

--
rbekka3
-----------------------------------------------------------------------
rbekka33's Profile: http://www.excelforum.com/member.php...fo&userid=1403
View this thread: http://www.excelforum.com/showthread.php?threadid=26307