declare @xlApp integer, @rs integer,@xlWorkbooks integer
,@xlWorkbook integer,@xlWorkSheet integer,@FileName varchar(100)
,@sql varchar(4000),@filepath varchar(250), @sd varchar(30),  @ed varchar(30),  @cd varchar(30),  @cmd varchar(30)
,@itable varchar(150), @mtable varchar(150),@srchstring varchar(200),@esrdp varchar(30),@esrdp2 varchar(6)

execute @rs = dbo.sp_OACreate 'Excel.Application', @xlApp OUTPUT
--turn off screen updating and displayalerts
--execute @rs = master.dbo.sp_OASetProperty @xlApp, 'ScreenUpdating', 'False'
--execute @rs = master.dbo.sp_OASetProperty @xlApp, 'DisplayAlerts', 'False'
--open workbook
--declare @xlWorkbooks integer
execute @rs = master.dbo.sp_OAMethod @xlApp, 'Workbooks', @xlWorkbooks OUTPUT
--declare @xlWorkbook integer
execute @rs = master.dbo.sp_OAMethod @xlWorkbooks, 'Open', @xlWorkbook OUTPUT, 'N:\ExcelMacro1.xlsm' 
--open worksheet
--declare @xlWorkSheet integer
execute @rs = master.dbo.sp_OAMethod @xlWorkbook, 'ActiveSheet', @xlWorkSheet OUTPUT
--clean up
execute @rs = master.dbo.sp_OAMethod @xlWorkbook, 'Close'
execute @rs = master.dbo.sp_OAMethod @xlApp, 'Quit'
--finally destroy all pointers
execute @rs = master.dbo.sp_OADestroy @xlWorkSheet
execute @rs = master.dbo.sp_OADestroy @xlWorkbook
execute @rs = master.dbo.sp_OADestroy @xlWorkbooks
execute @rs = master.dbo.sp_OADestroy @xlApp

quote:

---

Originally posted by dataguru1971

Do you have the macro set to run inside the xlsm files OnOpen event?]

Are you sure macros are enabled when the file opens?

---

Poor planning on your part does not constitute an emergency on my part.

---

quote:

---

Originally posted by dataguru1971

No, it is an excel issue..probably security inside of excel. Check this article :http://office.microsoft.com/en-us/excel-help/change-macro-security-settings-in-excel-HP010096919.aspx

---

Poor planning on your part does not constitute an emergency on my part.

---