open workbook
 

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

open workbook
 

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.

--
Regards,
Tom Ogilvy

"rbekka33" wrote in message
...

my macros work ok now but when i add the line to open the workbook - it
does so successfully but then stops and doesn't run through the other
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" dialogue
box which comes up.

is there any way of doing this?

cheers


--
rbekka33
------------------------------------------------------------------------
rbekka33's Profile:
http://www.excelforum.com/member.php...o&userid=14033
View this thread: http://www.excelforum.com/showthread...hreadid=263073