View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Excel 2007 - Workbook.Open Question

I have the following line that works in PowerPoint 2003, but doesn't in
PowerPoint 2007. I'm asking here because I think it's more of an Excel
question.

Set XLBook = XLApp.Workbooks.Open(sFile, UpdateLinks:=False)

I have everything dimensioned as needed. The error I'm getting is as
follows:

Run-time error '1004':

Excel cannot open the file 'FILENAME.xlsm'
because the file format or file extension is not valid. Verify that the file
has not been corrupted and that the file extension matches the format
of the file.

Thanks,

Barb Reinhardt