Thread: open workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rbekka33[_20_] rbekka33[_20_] is offline
external usenet poster
 
Posts: 1
Default 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