Sounds like XL can't find your template file. Are you sure the path and
filename are correct?

In article , xenod
wrote:

Hi, I have a problem with this code, when open a file excel show an
error runtime 1004 on add method, Why ?

Thanks for help


private sub aprifile()
Set EExcel = CreateObject("Excel.Application")
Set EWorkbook = EExcel.Workbooks

'Apre File Excel Template
Call EWorkbook.Add("p:\pubblica\procedure\modulistica\r ilevazione
personale.xlt")

EExcel.Visible = True
end sub